Jan 30 2019 10:26 AM
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
Jan 30 2019 10:29 AM
Jan 30 2019 11:17 AM