This appears to be a simple question but I am not sure why when I use the lookup function in Excel it does not display the correct value. For instance, when I select the cell that contains the list (text) and pick an item from it to display the corresponding value from the adjacent column, it works for the first (3) items but not for the fourth one. However, when I replace the text with a number, it works fine
When I use the vlookup function and pick High, it displays Proximal, etc, until I select Low - instead of displaying Pass, it displays Proximal. I am not sure why. However, when I replace the text in the left - High, Medium, etc with a number - 1, 2, etc. the function works fine. Can you assist me as to why this is the case? Thank you.
| High | Proximal |
| Medium | Zone |
| Moderate | Confirmation |
| Low | Pass |
When I use the vlookup function and pick High, it displays Proximal, etc, until I select Low - instead of displaying Pass, it displays Proximal. I am not sure why. However, when I replace the text in the left - High, Medium, etc with a number - 1, 2, etc. the function works fine. Can you assist me as to why this is the case? Thank you.
