Hello,
I'm having a problem with a VLookup function. I'm trying to compare values from 2 columns and return the value in a third column where the match is found. So I have entered:
=Vlookup(C2, Sheet1!A:B, 1, FALSE)
Column C on the current Sheet contains the values to look up, the corresponding values are in Column B on Sheet1 and I want to return the values from column A on Sheet1. I'm getting a #N/A error and when I view the calculation steps, I'm getting the following statement: The cell currently evaluate contains a constant."
I have viewed a number of other threads on this topic and tried the solutions suggested there. I can confirm:
- All cells in all 3 relevant column are formatted as "General"
- Column B in Sheet 1 is sorted ascending
- Column B definitely contains the values in question. I've spot-checked a few of them.
- I have read that copy-pasting can generate this error. Sheet1 is pasted from another Workbook. However, I have tried the same formula referencing the original workbook, instead of Sheet1, and had the same result.
- I have re-entered the formula after making any changes in the relevant columns
I'm afraid the sheet contains sensitive information about our clients, so I cannot post it here. If anyone has any suggestions as to why this error persists, I would greatly appreciate your input.
Thanks!
Bookmarks