M
MWS-C360
I'm using the VLOOKUP formula and I cannot determine why there is no return
on certain records, which should have a return.
For instance, I execute a macro to perform the VLOOKUP on one list, which
entries like: (TEXT)(SPACE)&(SPACE)(TEXT). The list I am cross referencing
has the exact same listing (ie I check =LEN and they match, I compared via an
IF statement and they match), yet I get #NA. The listing are text and the
range_lookup is not valued in the formula, so my thought is that the "&"
character may be the issue.
So, Are there any characters that cannot be used in combination with the
VLOOKUP formula - If yes, is there a site which I can obtain the list?
Any and all help will be appreciated - Thank You
on certain records, which should have a return.
For instance, I execute a macro to perform the VLOOKUP on one list, which
entries like: (TEXT)(SPACE)&(SPACE)(TEXT). The list I am cross referencing
has the exact same listing (ie I check =LEN and they match, I compared via an
IF statement and they match), yet I get #NA. The listing are text and the
range_lookup is not valued in the formula, so my thought is that the "&"
character may be the issue.
So, Are there any characters that cannot be used in combination with the
VLOOKUP formula - If yes, is there a site which I can obtain the list?
Any and all help will be appreciated - Thank You