Forum Discussion
VLOOKUP / Index Match returning different AND incorrect data
My VLOOKUP and Index Match functions are pulling different data, and both are incorrect data (not errors). This is a spreadsheet that has State and County data (example: State - Illinois, County - Co...
*
=VLOOKUP(H1,BIC!B2:F3623,2, TRUE)
That's bad formula #2. The lookup range should have absolute references.
https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
For the bad data try TRIM() - either in the formula or in a helper column. I suggest helper column first.
=VLOOKUP(H1,BIC!$B$2:$F$3623,1, FALSE)
When using this formula, I still get #N/A but if I switch to TRUE, I get the same result as not having absolute references.
The bad data TRIM() function I will have to dig into as I am completely unfamiliar with that
When using this formula, I still get #N/A but if I switch to TRUE, I get the same result as not having absolute references.
The bad data TRIM() function I will have to dig into as I am completely unfamiliar with that