Vlookup and Hlookup
 

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?

Vlookup and Hlookup
 

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


"cadustin" wrote:

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?

Vlookup and Hlookup
 

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)

--
Jacob


"cadustin" wrote:

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?

Vlookup and Hlookup
 

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




"Eva" wrote:


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


"cadustin" wrote:

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?

Vlookup and Hlookup
 

This problem has been solved! Thank you everyone who tried to help!!

"cadustin" wrote:

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?