lookup array

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi

Order ascending the Press size column

and try again

hth
regards from Brazil
Marcelo

"HFC-SC" escreveu:
 
Back
Top