| 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 |
| 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 | |||
Threaded Mode
