VLOOKUP with Transpose

Hey everyone,

Not sure if this can be done or not. I'm getting #REF's when I do this so maybe I have to do this a certain way. Anyway, I am getting data in my excel spreadsheet that is in Column B. I need to transpose the information so it goes in cells C1:X1. Those aren't the exact rows but just an example. So I got the transpose to work.

Now my problem comes with the VLOOOKUP. I typed in the formula properly with a lookup value that matched and then selected the table. I picked the column I wanted the formula to grab, and selected FALSE.

Am I doing anything wrong here?

Any help would be greatly appreciated.

Thanks!

I can't replicate I'm afraid, I repeated your steps (re: A1:A4 -> D1:G1, A in C1, VLOOKUP) and I get the correct result.

On an aside if you want to avoid using Transpose Array you can use INDEX:

D1: =INDEX($A$1:$A$4,COLUMNS($D1:D1))
copied across to G1 will produce same output

EDIT: per your upload the Column reference in the VLOOKUP should be 2 and not H9, also it is not an Array formula - commit with ENTER as normal (not CTRL + SHIFT + ENTER)