Excel: VLOOKUP not returning expected results for repeated lookup values
Posted on 2004-10-25
I'm working on an Excel spreadsheet that needs to perform a lookup.
Table A is looking up a value in Table B and returning the corresponding value in Table B to Table A. Table B contains only unique lookup values, while Table A contains multiple occurances of the same lookup value. The first instance of the value in Table A returns the correct result while all duplicates return error messages (#N/A).
Here's the Vlookup formula: =VLOOKUP($A1,'Master'!$A:$H,6,FALSE)
Any thoughts? Let me know if you need more info...