Forum Discussion
Solved
Vlook up Error
Hi Community, I'm trying to do a vlookup to capture the values from my second sheet( Values). This is the formula I used below. Ideally, I want the C column on the master sheet to read Rejected,...
Testbot1 The lookup values (column A on the Master sheet) are a mix of texts and numbers. Text "17" is not equal to number 17, hence #N/A#
First, you will need to reverse the order of the table being used for looking up those possible returns, so it begins with the lower numbers, and you want the bottom (lowest) number to be zero
| 0 | Out of range |
| 3 | Error |
| 15 | Cancelled |
| 16 | Approved |
| 17 | Rejected |
Then, if the only numbers that are ever going to appear in column A are the ones in the table) your formula should work. Otherwise, for a range lookup, you would want the final word in that formula to be "True"
=VLOOKUP(A2,Values!$A$1:$B$4,2,TRUE). or, I always find it easier to use 1 or 0, as in
=VLOOKUP(A2,Values!$A$1:$B$4,2,1)
- Thank you! This and the combination of response above solve the issue
