Home

Transpose Vlookup Table

ChadBoronow
Occasional Contributor

Does anyone know if it is possible to run a verticle vlookup?

 

Example Table:

         A                       B                   C                Z

1  Address              County           State          County

2  123 Road           Adams            PA

3  321 Street          York                PA

 

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)

 

Can i do this? Thanks in advanced

 

3 Replies
Highlighted
I guess that would be a horizontal vlookup actually xD
It's called an 'Hlookup'
well huh... i feel dumb but that would make sense lol. Thanks
Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies