Hi,
I am trying to use Vlookup to populate a couple of fields in my table. I keep getting an error "N/A" in columns F and G. I have looked at the formatting and cannot see anything obvious that may be causing this error.
Can anyone help?
Thanks
Deepak
Hi Deepak,
You have two issues, firstly the range you're looking up in your VLOOKUP formula is A1:K162 but the Folder column in Sheet 2 is in column B, so your lookup range should be B1:K162, and therefore the col_ref_num argument should be 8 instead of 9.
The second issue is that in Sheet2 the Folder numbers are actually numbers, despite you setting the cell format to text. The Folder numbers in Sheet1 are text, hence why you see the green warning triangle telling you these numbers are stored as text.
You need to either fix the Folder numbers in Sheet1 so they're numbers; select the range of numbers and use the green indicator option to convert them to text, or convert the Folder numbers in Sheet2 to text using Text to Columns. The former is easiest and recommended.
Let us know if you get stuck.
Mynda
