Greater than or equal to

[Melanie Strom]

I have a reference sheet (1) with a column for age and one
for projected value. Another sheet (2) contains a VLOOKUP
referring to the sheet 1. There is one value for ages
65+. So on sheet 1 the age column reads ">=65".

The problem is that when someone is 65 or older, as
entered on sheet 2, the VLOOKUP doesn't pick up the
projected value.

Do I need to enter each age, 65 and above, on a separate
row in sheet 1 or is there a formula I can enter on that
sheet and just list the value once?

 

[Don Guillett]

try using 65

 

[Melanie Strom]

I can't use that because if someone is 66, for example, it
won't pick up the number because there is no 66 on sheet
1. That's why I'm asking if I need to have a row for each
age, 65 and over.

 

[Melanie Strom]

Instead of fixing sheet 1, I changed the VLOOKUP cell to
an if formula: =IF(E130>=65,1,(VLOOKUP(E130,'Table A--
need for reference'!A:B,2,0))). This works fine.