Thread: Mixing IF & VLOOKUP Statements?

Hello - I am a very basic at excel and I was given the task of trying to match numbers to letters. I added a attachment to better explain. So basically if the cell C4 has the number 3 then I need the letter in A3 to display. I got a function that "works" but it doesn't go across the columns at all.

=IF(C4,VLOOKUP(A22,$A$1:$A$33,COLUMNS(C3),FALSE),0)

Please help me.

I hope this what you need

tom1977

Wow. Thanks!

...could also use indirect:

=INDIRECT("A" &C4)