Vlookup returning no results
Our take
I've been working in Excel and writing vlookups since Excel was Symphony 123. Whenever vlookups don't work, I'm baffled for the longest time but can usually detect my error. Not this time.
The first picture shows the column I'm trying to pull from (column E). The second shows the column I'm trying to pull column E row 267 into (column O).
My formula in column N (which works) is the same as it is in column O (which doesn't work--the result should be 6) except I'm referencing column E instead of column D (5 columns over from A instead of 4). So the formula in column N is =VLOOKUP($K266,$A:$J,4,FALSE)*$M266 and the formula in column O is =VLOOKUP($K266,$A:$J,5,FALSE)*$M266.
What am I missing?? All the columns are formatted identically to one another. (Yes, I did notice in my screen shots that only one decimal place is showing in column E and two in column O. I corrected that and still no 6 as a result.)
[link] [comments]
Read on the original site
Open the publisher's page for the full experience