| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup table with specific criterea
The following is an example of a spreadsheet with 3 columns.
Col 1 Col 2 Col 3 ABC .50 03/07/06 DEF .25 03/07/06 GHI .65 03/07/06 JKL .35 03/07/06 ABC .90 03/14/06 DEF 2.99 03/14/06 JKL 4.15 03/14/06 Here is another spreadsheet. Col 1 Col 2 ABC .90 DEF 2.99 GHI n/a JKL 4.15 How can I create a formula the bring in col 2 automatically from my first spreadsheet based on the most current date from col 3 of my first spreadsheet? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a lookup table with an added varable? | Excel Worksheet Functions | |||
| Lookup in table with two equal references | Excel Discussion (Misc queries) | |||
| need Lookup table to return null or zero | Excel Worksheet Functions | |||
| Pivot Table - Extracting specific data | Excel Worksheet Functions | |||
| How do I lookup a table from right to left ? | Excel Worksheet Functions | |||
Threaded Mode
