| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable Table Array in Lookup Function | Excel Worksheet Functions | |||
| Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
| Lookup Array Formula | Excel Worksheet Functions | |||
| Array | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Linear Mode
