Forum Discussion
Vlookup that returns "text" not data from the table
I want to perform a Vlookup (or assume I do), but I want to return "text" rather than a value from the data table.
my vlookup formula is:
=IFERROR(VLOOKUP(G34,RANGED!A:B,1,0),"")
Where I return "1" above, I want to show "text"
The 3rd argument of VLOOKUP - the 1 in your example - is the column index. It must be a number between 1 and the number of columns of the lookup range. Since your lookup range RANGED!A:B, the column index can be 1 or 2.
Can you explain what you want to accomplish?
- Hi Hans, thank you so much for looking at this for me. I have had inhouse assistance and we have accomplished what was required via:
=IF(ISERROR(VLOOKUP(G34,RANGED!A:B,1,0)),"","Ranged")
I apologise that my message was unclear, but when I showed the inhouse team what I wanted, they provided the above.
