Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Excuse me if this appears a stupid request
Have 2 collums "From" & "To" and wish excel to look up a table that would match the cell values of these collums exactly then enter the price in the third collum of the table. Example a=Hotel name, b=Airport, want c to be a cost that is shown in a seperate table that has fthe from, to and cost values So when I enter the job details on my worksheet it automatically puts in the price from the other table. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
Changing one cell colour by inserting date in another cell | Excel Worksheet Functions | |||
Split a Blank Cell into Two (Without Inserting Cell) | Excel Discussion (Misc queries) | |||
Inserting two cell values into a new cell + text | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel |