My apologies for a typo. The correct formula is

=VLOOKUP(E1,$A$1:$D$50,MATCH(E2,$A$1:$D$1,0),0)

with the correction in RED.

BTW, this is just one formula you can use. Another one you can use is
an INDEX/MATCH formula (which you found to be already working).

Regards and again, I apologize for sending you an earlier formula with
a typo.


dread Wrote:
I get #N/A

"BenjieLop" wrote:


Try this ...

=VLOOKUP(E1,$A$1:$D$50,MATCH(E2,$A$1:$D$50,0),0)

whe

cell E1 contains your Model Number (Model A, Model B ... whatever)
cell E2 contains your room (Bath, Kitchen. Laundry... whatever)
$A$1:$D$50 is the assumed range of your table.

Hope this will help you.

Regards.



dread Wrote:
Is it possible to use 2 look up values in VLookup? Or is there a
different
method I should be using?

For example:

Kitchen Bath Laundry
Model A Price A Price B Price C
Model B Price D Price E Price F

I have the model stored in cell A1 and the room stored in cell B1.
I
want
to look up the model (in cell A1) and the room (in cell B2) in the
table
array (above) and return the appropriate price. If I have Model A
and
Kitchen, I want VLookup to return Price A. If I have Model A and
Bath
I want
VLookup to return Price B and so on.

Thank you.


--
BenjieLop



------------------------------------------------------------------------
BenjieLop's Profile:
http://www.excelforum.com/member.php...o&userid=11019
View this thread:
http://www.excelforum.com/showthread...hreadid=555674




--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=555674