lookup array
 

Sheet 1 below:

A13 is a lookup from Sheet 2. I want the cell B13 to take this value and
lookup the column 1 and enter the value into B:13.

=LOOKUP(A13,A2:B11) but get this #N/A? What am I doing wrong?


PRESS SIZE Rate $
K68 250
K813 300
K1014 400
K1214 500
K13517 550
K13518 600
E1395/870 300
E1420/1020 400
E1650/1380 550
E1900/1450 550

K1214 #N/A

lookup array
 

Hi

Order ascending the Press size column

and try again

hth
regards from Brazil
Marcelo

"HFC-SC" escreveu:

Sheet 1 below:

A13 is a lookup from Sheet 2. I want the cell B13 to take this value and
lookup the column 1 and enter the value into B:13.

=LOOKUP(A13,A2:B11) but get this #N/A? What am I doing wrong?


PRESS SIZE Rate $
K68 250
K813 300
K1014 400
K1214 500
K13517 550
K13518 600
E1395/870 300
E1420/1020 400
E1650/1380 550
E1900/1450 550

K1214 #N/A

lookup array
 

Many thanks this works fine.

"Marcelo" wrote:

Hi

Order ascending the Press size column

and try again

hth
regards from Brazil
Marcelo

"HFC-SC" escreveu:

Sheet 1 below:

A13 is a lookup from Sheet 2. I want the cell B13 to take this value and
lookup the column 1 and enter the value into B:13.

=LOOKUP(A13,A2:B11) but get this #N/A? What am I doing wrong?


PRESS SIZE Rate $
K68 250
K813 300
K1014 400
K1214 500
K13517 550
K13518 600
E1395/870 300
E1420/1020 400
E1650/1380 550
E1900/1450 550

K1214 #N/A

lookup array
 

thanks for the feedback

regards
Marcelo

"HFC-SC" escreveu:

Many thanks this works fine.

"Marcelo" wrote:

Hi

Order ascending the Press size column

and try again

hth
regards from Brazil
Marcelo

"HFC-SC" escreveu:

Sheet 1 below:

A13 is a lookup from Sheet 2. I want the cell B13 to take this value and
lookup the column 1 and enter the value into B:13.

=LOOKUP(A13,A2:B11) but get this #N/A? What am I doing wrong?


PRESS SIZE Rate $
K68 250
K813 300
K1014 400
K1214 500
K13517 550
K13518 600
E1395/870 300
E1420/1020 400
E1650/1380 550
E1900/1450 550

K1214 #N/A