VLOOKUP to the Right

[Rumpkin]

I have this formula:
=IFNA(VLOOKUP(1,$C26:$F33,4,),"")
I would like to swap 1 for a 2 and the 4 for a 1.
Changing the formula to:
=IFNA(VLOOKUP(2,$F26:$G33,1,),"")
I am having to use "column 1" as a slave that references another column
Is this possible?

 

[Joe4]

Not quite sure what you mean. VLOOKUP already returns a value to the right of the cell you are matching on.
Perhaps you mean the other way (to the "left").
If so, see this: https://www.excel-university.com/how-to-return-a-value-left-of-vlookups-lookup-column/

If that does not answer your questions, please layout an actual data example for us, so we can see exactly what your data is doing, and what you are trying to do.