goodmachine
Board Regular
- Joined
- Oct 7, 2009
- Messages
- 70
Hello,
I'm having difficulty with a VLOOKUP that is not retrieving known results. Hence, I can't trust the data.
I've done a variety of things to clean up the source data (table array)
None of these returned the desired LOOKUP return.
I also changed my lookup fomula to include, e.g., =VLOOKUP(TEXT(A227,0),Kit!B1:B1729,2,FALSE)
Any other ideas about what I can do? Any other formulas I could try (e.g., index match).
I'm having difficulty with a VLOOKUP that is not retrieving known results. Hence, I can't trust the data.
I've done a variety of things to clean up the source data (table array)
- Converted cell to a number
- Changed cell format to general
- Removed any extra spaces
- Changed the column position of the table array
None of these returned the desired LOOKUP return.
I also changed my lookup fomula to include, e.g., =VLOOKUP(TEXT(A227,0),Kit!B1:B1729,2,FALSE)
Any other ideas about what I can do? Any other formulas I could try (e.g., index match).