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?