reverse vlookup?

**tn80** · 09-17-2008, 05:44 PM

hi,
i need to vlook up values in cols C, E, G and return values in column A. (Please see attached file) The desired results are in columns K, M, O.

Is it possible to do a reverse vlookup without moving around the columns? I know it's possible to do a reverse hlookup by using countif and offset but was wondering if it's possible w. vlookup.

Many thanks!

**protonLeah** · 09-17-2008, 07:52 PM

The formula below, placed in J6 and copied down, works for the first case. I did not work on the others but something similar should work.

Please Login or Register  to view this content.

**Ikaabod** · 09-17-2008, 08:07 PM

Below is a modified version of your reverse hlookup formula, you can copy/paste across and down.

Please Login or Register  to view this content.

Of course you can change "n/a" to "" if you want it to return blanks.

**daddylonglegs** · 09-17-2008, 08:12 PM

The standard approach for a "left lookup" is to use INDEX/MATCH, e.g. in K6 copied down

=IF(ISNA(MATCH($J6,C$6:C$17,0)),"",INDEX($A$6:$A$17,MATCH($J6,C$6:C$17,0)))

and similar for your other columns.

Note: some of your dates in columns E and G are 2008 dates, should these be 2003?

**tn80** · 09-17-2008, 11:08 PM

Hi protonLeah, Ikaabod, and daddylonglegs,

Thank you very much for your replies. These are great solutions. Exactly what I was looking for. This forum rocks!

Thanks,

PS: daddylonglegs, yes the dates are supposed to be 2003, good catch! :D