I know how to use the Vlookup function in Excel in a cell to lookup a value against 1 criteria field.
is it possible to do the same for a 2 criteria field. so, i need to know if both cells match before i can give the result.
any help would be great.
07-19-2001, 10:06 AM
Set up 2 columns with your 2 separate VLookup criteria, then a third column to compare those two values. If both are True, then do your thing. Maybe not the most efficient way of doing it, but it works.
thx i'll try that.
just from an academical point of view, is there a more esthetic way of doing this? can you do a Vlookup within a Vlookup?
07-19-2001, 11:15 AM
Not that I know of, but you of course don't have to have the two VLookup columns visible, you can reduce the width to 0 so they don't even show when people are looking at your data.
thx m8 for your help but i found another way.
Don't tease us Adi images/icons/smile.gif What did you come up with?
unfortunately exhalted one, i cheated.
the whole reason for this was for me to be able to bring up a table of data using a pivot sheet. so i have a value on top (years) and a value on the left (names). the years are supposed to be a fixed column
i complete a process of preparing the data after using a vlookup on the name to get a result. unfortunately, if there is a break in the year count (2001, 2002, 2004, 2005...) my fixed column routine fails. that's where i tryed to use a double vlookup which didn't actually work for this scenario.
what i've done then is cheated. i forced the source data to have a year for each section of data. therefore, there is no break in years and a fixed reference can be applied.
i would still love to know if there is a way you can use a double Vlookup in an easy manner but i guess that is still a mystery to be solved.
hope i didn't bore you.
07-20-2001, 09:17 AM
np, sorry I couldn't help on this. If the file is <50k I would be interested in taking a look at it, though.