ExcelBanter - vlookup: data same in 2 tabs yet get #N/A when shouldn't

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - vlookup: data same in 2 tabs yet get #N/A when shouldn't (https://www.excelbanter.com/excel-discussion-misc-queries/228926-vlookup-data-same-2-tabs-yet-get-n-when-shouldnt.html)

CMAXWELL

vlookup: data same in 2 tabs yet get #N/A when shouldn't

I know there must be a reason that data/number not recognized, but changing
formatting doesn't help - would have to retype numbers to get vlookup to
recognize. Any quick fixes?

Maurice

vlookup: data same in 2 tabs yet get #N/A when shouldn't

Multiply the outcome by 1 something like:

Vlookup(lookupvalue,tablerange,column,false)*1

hth
--
Maurice Ausum

"CMAXWELL" wrote:

I know there must be a reason that data/number not recognized, but changing
formatting doesn't help - would have to retype numbers to get vlookup to
recognize. Any quick fixes?

All times are GMT +1. The time now is 12:26 AM.