G
Guest
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.
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.