Vlookup in excel

Hi,

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.

Adi

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.

______
Cheers!

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?

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.

______
Cheers!

thx m8 for your help but i found another way.

Adi.

Don't tease us Adi images/icons/smile.gif What did you come up with?


JDT

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.

Adi

np, sorry I couldn't help on this. If the file is <50k I would be interested in taking a look at it, though.

______
Cheers!