Vlookup Error / Imported Data Format
I am trying to bring the values in column B of "Forum Data 010512" into column O of "Forum Import 010512" using a simple Vlookup. The Vlookup I'm using in column O is =VLOOKUP($F:$F,'[Forum Data 010512.xlsx]Data'!$A:$B,2,0). The result is #N/A even when the data file has a value in column B.
I suspect that this has something to do with the fact that the information in the data file originated from an outside source. I have tried scrubbing/formatting the data nine ways to Sunday but cannot get the vlookup to give the me values.
Someone please help me before I throw myself out of the window!
Last edited by pleiadeez7; 01-06-2012 at 10:34 AM.
THe reason it isn't matching is because the values in column A look like numbers but are text. See the green triangles in the corner? Excel is trying to warn you about that.
The values in column F of the other sheet look like numbers and ARE numbers. So they aren't the same thing. It's easy to adjust for that.
The formula in O2, then copied down, would be:
=VLOOKUP($F2&"", '[Forum Data 010512.xlsx]Data'!$A:$B, 2, 0)
That part in red changes the F2 number into text so it can match the other sheet. But there is no match. The first real match appears in O98.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Thank you! Something so simple...and I have spent hours trying to fix that. I should have come here first!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks