| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
look up value in a table
I have a spreadsheet with Pipe Dia in one columnn a1 and pipe thickness b2
in another column. In a another sheet i have a pricing table Pipe Thickness Pipe Dia 3 4 6 7.5 9 4 $1 $2. $3 $4 $ 5 6 $3 $4 $5 $ 5 # 6 8 3.5 4.5 5.5 6.5 7 I would like to write index or lookup function that will return the following. If pipe diameter in a1 =8 and pipe diamter b2 =6 it will return $5.5 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
look up value in a table
You could use match to identify which column to return in a vlookup.
Assuming your table is in A1:F5 (pipe diameters in column A and pipe thickness figures are in row 2): =Vlookup(PipeDia, A3:F5, Match(PipeThickness, A2:F2, 0), 0) "joe" wrote: I have a spreadsheet with Pipe Dia in one columnn a1 and pipe thickness b2 in another column. In a another sheet i have a pricing table Pipe Thickness Pipe Dia 3 4 6 7.5 9 4 $1 $2. $3 $4 $ 5 6 $3 $4 $5 $ 5 # 6 8 3.5 4.5 5.5 6.5 7 I would like to write index or lookup function that will return the following. If pipe diameter in a1 =8 and pipe diamter b2 =6 it will return $5.5 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
look up value in a table
thanks
it works "JMB" wrote: You could use match to identify which column to return in a vlookup. Assuming your table is in A1:F5 (pipe diameters in column A and pipe thickness figures are in row 2): =Vlookup(PipeDia, A3:F5, Match(PipeThickness, A2:F2, 0), 0) "joe" wrote: I have a spreadsheet with Pipe Dia in one columnn a1 and pipe thickness b2 in another column. In a another sheet i have a pricing table Pipe Thickness Pipe Dia 3 4 6 7.5 9 4 $1 $2. $3 $4 $ 5 6 $3 $4 $5 $ 5 # 6 8 3.5 4.5 5.5 6.5 7 I would like to write index or lookup function that will return the following. If pipe diameter in a1 =8 and pipe diamter b2 =6 it will return $5.5 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivit table- cell on spread sheet referencing pivot table field | Charts and Charting in Excel | |||
| entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
| Insert rows in linked table that are added to secondary table | Excel Discussion (Misc queries) | |||
| Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) | |||
| PIVOT TABLE - Summary Table into a Databasae Table. | Excel Worksheet Functions | |||
Linear Mode
