Transpose Vlookup Table

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
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
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Custom value if a value is found using vlookup
Sam55 in Excel on
5 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies
vlookup using concatenate function and helper column
Angela McGhin in Excel on
4 Replies
Vlookup doesn't work for inexplicable reason
Domonkos in Excel on
2 Replies
BowlingAlleyBob in Excel on
3 Replies