DoubleBitAxe
New Member
- Joined
- Dec 12, 2016
- Messages
- 2
I have data in a table that looks like a cell reference (namely, they are part numbers of the form N######) with parameters about each part. I am trying to use VLOOKUP to find the part of interest and extract particular parameters, but for numbers below 200000, for example N123456 excel sees it as a cell reference and looks for the value in cell N123456, which is typically a blank cell.
Is there a way to tell excel that I want it to use the value in the cell, not treat it as a reference? Sort of like the opposite of the INDIRECT function?
Thank you in advance.
Is there a way to tell excel that I want it to use the value in the cell, not treat it as a reference? Sort of like the opposite of the INDIRECT function?
Thank you in advance.