Vlookup and Hlookup

[cadustin]

I am trying to figure out something that may be very simple, but I am not
getting it. I want Vlookup to look at two things to bring back an answer.
Here is my example

HMO PPO DENTAL VISION
EE 10.00 12.00 5.00 5.00
EE+Sp 15.00 20.00 10.00 10.00
EE+Ch 12.00 15.00 7.00 7.00
EE+Fa 20.00 30.00 15.00 15.00

How do I have excel look at the top to see what insurance I am looking for,
then read the side to see what the coverage is and then give me the
corresponding amount?

 

[Eva]

G H I
2 Data Data
3 EE HMO 10.00 the formula

=INDEX(A1:E5,MATCH(G3,A1:A5,0),MATCH(H3,A1:E1,0))


--
Please click "yes" if this post helped you!

Greatly appreciated

Eva

 

[Jacob Skaria]

Another way..

Replace the text string with cell references...

=VLOOKUP("EE",A1:E5,MATCH("HMO",A1:E1,0),0)
OR
=HLOOKUP("HMO",A1:E5,MATCH("EE",A1:A5,0),0)

 

[cadustin]

Hi Eva, I am still getting the error message of #N/A:

BENEFIT COVERAGE COST
HMO Employee & Spouse #N/A

Here is the formula I entered:
=INDEX('Look Up Sheet'!A1:E5,MATCH(A5,'Look Up
Sheet'!A1:E5,0),MATCH(B5,'Look Up Sheet'!A1:E5,0))

Here is my look up information (on another sheet)

HMO PPO DENTAL VISION
Employee Only $269.20 $291.39 $15.32 $5.06
Employee & Spouse $592.24 $641.06 $29.50 $8.57
Employee & Child $524.93 $568.20 $31.00 $8.65
Employee & Family $855.42 $890.20 $53.69 $14.35