If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|