Forum Discussion
HLOOKUP Into VLOOKUP in two separate sheets.
=VLOOKUP(A2,'Prices per Zone'!$B$2:$O$27,MATCH(H2,'Prices per Zone'!$B$1:$O$1,0),FALSE)
I entered 2 sample sheets and set up the formula according to your data. Above formula should work.
Please note that this formula looks similar to the one i suggested yesterday but there is an important difference. The lookup value will be found in column B and then formula returns the expected result.
=VLOOKUP(A25,'Prices per Zone'!$C$2:$AQ$36, MATCH(H25,'Prices per Zone'!$C$1:$AQ$1,0),0)
Maybe this works. With match function you can check in which column the area were it should go is entered.
Thanks for replying! Unfortunately, that didn´t seem to work. But I tried using an IF formula, and I got somewhere with it. Still some minor errors, but they are more workable.
As the IF formula was so long, I had to create 2 CONCAT formulas to narrow the size down. The used the VLOOKUP formula to read in a normal way and link into the IF formula. Not sure if this makes sense, its quite a process, but it should make things easier in future.
=VLOOKUP(A2,'Prices per Zone'!$B$2:$O$27,MATCH(H2,'Prices per Zone'!$B$1:$O$1,0),FALSE)
I entered 2 sample sheets and set up the formula according to your data. Above formula should work.
Please note that this formula looks similar to the one i suggested yesterday but there is an important difference. The lookup value will be found in column B and then formula returns the expected result.
- Thank you for your help!
