View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MyLan MyLan is offline
external usenet poster
 
Posts: 3
Default Vlookup and Hlookup Combine?

Hi,

I have a table like this:

Model Option 1 Option 2 Option 3
A $10 $15 $5
B $20 $17 $5
C $30 $19 $5

Now i want to find the value of the Model A and Option 3 or Model A and
Option 1 or so on...
Would any one can help me to create an formula which combine the vlookup and
Hlookup together...

Much appreciated.
Thanks,
MyLan