T
Tom Hawley
I'm having some trouble with VLOOKUP in Excel 2000 and after extensive
Googling i'm none the wiser.
We have an Access 2000 database, some data from which I am exporting into an
XLS. I'm trying to x-ref this with a monthly Excel (not initially 2000 but
later saved in that format) report, with the tried and tested method of
adding a column of VLOOKUP(refno, namedtable, 2, FALSE) to link in a column
of information from the database to relevant lines in the report.
I'm certain i'm doing it correctly, but in some circumstances it seems two
cells seem not to equate when they actually contain the same value (and even
the same cell type). I've managed on occasion to right this by modifying
other cell formatting such as text alignment, but this has not always
helped. In short, i'm getting a list of #N/A's where I can see there should
be matches, i'm using FALSE so the table need not be sorted, and it makes no
difference if it is, and also running a basic cell=cell on like cell refs
involved actually returns FALSE.
Could somebody tell me what it is thats causing this?
Googling i'm none the wiser.
We have an Access 2000 database, some data from which I am exporting into an
XLS. I'm trying to x-ref this with a monthly Excel (not initially 2000 but
later saved in that format) report, with the tried and tested method of
adding a column of VLOOKUP(refno, namedtable, 2, FALSE) to link in a column
of information from the database to relevant lines in the report.
I'm certain i'm doing it correctly, but in some circumstances it seems two
cells seem not to equate when they actually contain the same value (and even
the same cell type). I've managed on occasion to right this by modifying
other cell formatting such as text alignment, but this has not always
helped. In short, i'm getting a list of #N/A's where I can see there should
be matches, i'm using FALSE so the table need not be sorted, and it makes no
difference if it is, and also running a basic cell=cell on like cell refs
involved actually returns FALSE.
Could somebody tell me what it is thats causing this?