lookup array

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
 
G

Guest

Hi

Order ascending the Press size column

and try again

hth
regards from Brazil
Marcelo

"HFC-SC" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup or reference function needed 3
Double V lookup 1
How to dynamically add up varying # of cells base on a value 12
Hlookup and sum noncontiguous numbers 1
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Excel - find where a number falls in a start and end range 3
table programming dlookup & insert into vs query 7
Save user entered value in hidden lookup table. 4

Top