B
BarryNeaves
I am trying to create a formula in MS Excel 2000.
I am looking at a fixed value ab123456c in a cell, formatted as text.
I want to look at a range of a different table, to respond that it has
found an exact match, and to look up a date next to the ab123456c and
return the date into the formula cell, or FALSE if there's no match.
I have used the VLOOKUP function, but it seems to return the closest
match and not an exact match, if the correct match is not available.
=VLOOKUP($F$2,'[differentbook.xls]sheet1'!$A$10:$F$403,2,TRUE)
Hopefully you'll be able to understand the above, it sounded better in
my head....
can anyone help correct this? or suggest an alternative?
Many thanks.
I am looking at a fixed value ab123456c in a cell, formatted as text.
I want to look at a range of a different table, to respond that it has
found an exact match, and to look up a date next to the ab123456c and
return the date into the formula cell, or FALSE if there's no match.
I have used the VLOOKUP function, but it seems to return the closest
match and not an exact match, if the correct match is not available.
=VLOOKUP($F$2,'[differentbook.xls]sheet1'!$A$10:$F$403,2,TRUE)
Hopefully you'll be able to understand the above, it sounded better in
my head....
can anyone help correct this? or suggest an alternative?
Many thanks.
)