Formula ?
Try the INDEX() MATCH() combination instead of VLOOKUP() when the lookup
value is not the 1st column in the array...
=INDEX(A:A,MATCH(C2,B:B,0))
--
Jacob (MVP - Excel)
"Joe" wrote:
I got 3 columns in excel. First two is ID & Name, third column is a subset of
the 2nd Column. Now, I want the corresponding ID's for my 3rd column (which
should be looked up in first 2 columns) in my 4th column.
ID,Name,Subset-name,Subset-ID?
--
Failing to plan is planning to fail
|