This is driving me NUTS!

F

Frank Kabel

Hi
you may post the formula you've used
-----Original Message-----
For some reason, I just can't get the data I'm looking
Click to expand...
for. I want Excel to give me a result for the Dental
columun and I keep getting N/A#.
C D E
F I J
PLAN LIFE AD&D DENTAL PREMIUM
Click to expand...
TABLE EMPLOYEE
2.50 .50 22.36
EMPLOYEE
E+SPOUSE 2.50 .50
Click to expand...
47.00 E+SPOUSE E+CHILDREN
2.50 .50 53.60
E+CHILDREN E+FAMILY
2.50 .50 72.56
E+FAMILY
 
F

Frank Kabel

Hi
and have you checked that the value in cell C2 is within
the cell range I3:I7
(watch for spaces, formats, etc.)

You may check this manually. e.g. if you assume taht cell
C2 is equal to I4 enter the formula
=C2=I4

this should return TRUE. Otherwise check spaces, formats,
etc.
 
F

Frank Kabel

Hi
have you tried
=C2=I4

does this really return tRUE?. If yes you may email me
your file
frank[dot]kabel[at]freenet[dot]de
-----Original Message-----
Absolutely!! I copied the values right from the C column
Click to expand...
to create the table I3:I7. I just can't figure it out!
What I've done is resort to AutoFilters at the top of the
column to show the coverage types in the C column and
entered the corresponding values that way. However, that
is so MANUAL, and wanted the VLOOKUP to do it for me.
 
T

Teri

Frank, I did test and it came back TRUE. Am sending file. Thanks so much for your help!

Frank Kabel said:
Hi
have you tried
=C2=I4

does this really return tRUE?. If yes you may email me
your file
frank[dot]kabel[at]freenet[dot]de
-----Original Message-----
Absolutely!! I copied the values right from the C column
Click to expand...
to create the table I3:I7. I just can't figure it out!
What I've done is resort to AutoFilters at the top of the
column to show the coverage types in the C column and
entered the corresponding values that way. However, that
is so MANUAL, and wanted the VLOOKUP to do it for me.
COBRA .00 .00
.
Click to expand...
Click to expand...
 
D

Dave Peterson

You're retrieving the first column (I) of your table:

=VLOOKUP(C2,I3:J7,1,FALSE)

It's difficult to see what column you really want, but maybe:

=VLOOKUP(C2,I3:J7,2,FALSE)

Look in I3:I7 for a match with C2, then return what's in column J of that
matched row.
 
Top