Transpose Vlookup Table

Question

Does anyone know if it is possible to run a verticle vlookup?&nbsp;Example Table:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Z1&nbsp; Address&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; County&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;State&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; County2&nbsp; 123 Road&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Adams&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PA3&nbsp; 321 Street&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; York&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PA&nbsp;So essentially what i want to do is =vlookup(Z1,A1:C3,[2],False) but instead of the [2] giving the result in the 2nd column (in this it would return "State") I want the result in the 2nd row (so "Adams" would be the result)&nbsp;Can i do this? Thanks in advanced&nbsp;

chadboronow · Answer

I guess that would be a horizontal vlookup actually xD

cfaith · Answer

It's called an 'Hlookup'

chadboronow · Answer

well huh... i feel dumb but that would make sense lol. Thanks

Forum Discussion

Transpose Vlookup Table

Share

Resources