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
|