Lookup Help

Chookie73

New Member
Joined
Apr 23, 2006
Messages
1
Hi fellow excel users, I am trying to do a lookup between two tables in which I need to lookup on 2 criteria, to identify the items as individual.

Is there a way that I can do a vlookup or some other king of lookup which say if x and y = a and b give me cell j

Thanks
:biggrin:
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
For an sbstract spec, an abstract answer...

=INDEX(Jrange,MATCH(1,IF(Xrange=a,IF(Yrange=b,1)),0))

which must be confirmed with control+shift+enter, not with enter.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,051
Messages
5,545,725
Members
410,702
Latest member
clizama18
Top