Nov 19 2022 11:01 PM
I want to perform a Vlookup (or assume I do), but I want to return "text" rather than a value from the data table.
Nov 19 2022 11:11 PM
my vlookup formula is:
=IFERROR(VLOOKUP(G34,RANGED!A:B,1,0),"")
Where I return "1" above, I want to show "text"
Nov 20 2022 03:58 AM
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?
Nov 20 2022 04:39 PM
Nov 21 2022 12:49 AM