Pulling from a Vertical worksheet and goes to a Horizontal Spreadsheet

[jjweaver]

I am trying to pull information from a Vertical worksheet and put into another worksheet. This is what I have been doing for the past year, but it is time consuming changing the row numbers of the people.

=HLOOKUP($B53,'S:\Corporate\Loss Prevention\Schedules\2019\[Southeast.xlsx]Data Entry'!$D$1:$AQ$700,390,FALSE)

I have never used Index/Match so I don't even know if that is an option. Just wanted to see if there was something easier.

Thanks for your help!

 

[DSCfromCFA]

I would suggest that the TRANSPOSE function, found under 'Lookup & Reference' will do the trick.