Forum Discussion

H_Stuart's avatar
H_Stuart
Copper Contributor
Nov 23, 2021
Solved

HLOOKUP Into VLOOKUP in two separate sheets.

Hello All,    I'm working on a sheet that calculates different prices for our products according to where it gets delivered. It´s a lot of data to load manually, so I´m trying to make it read from ...
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Nov 24, 2021

    H_Stuart 

    =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.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Nov 24, 2021

H_Stuart 

=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.

H_Stuart's avatar
H_Stuart
Copper Contributor
Nov 29, 2021
Thank you for your help!

Resources