Here's how I finally got it to work:

=INDEX('Data Table'!$Y$6:$AI$23, MATCH($B$5,'Data Table'!$Y$6:$Y$23,),
MATCH($A$13,'Data Table'!$Y$6:$AI$6,)). I used the Lookup wizard to get it
to populate the formula and then I changed the MATCH lookup value arguments.

Thanks for your help!


"Bob Phillips" wrote:

=INDEX(A1:D3,MATCH("Model A",A1:A3,0),MATCH("Bath",A1:D1,0))

as an example

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"dread" wrote in message
...
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.