| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP over three spreadsheets
Can you show the sample of the data and how it should looks like?
-- Greatly appreciated Eva "Ksean" wrote: With this problem I am dealing with a workbook that contains three spreadsheets €˜Financial, €˜Registrants and €˜Start The answer/formula is to be in cell J3 on sheet €˜Financial so Ill start there now match the value in cell A3 on sheet €˜Financial to the value somewhere in column B (B3:B800) on sheet €˜Registrants, once a match has been found then go to column G on that row which has a date in it (i.e. May 8, 1996) and match only the year to the year somewhere in column B (B26:B47) of sheet €˜Start, once a match has been found then go to column E on that row, now display the contents of that cell back in cell J3 on sheet €˜Financial. Thanks Ksean |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using VLOOKUP Across Multiple Spreadsheets | Excel Discussion (Misc queries) | |||
| VLookup multiple spreadsheets | Excel Worksheet Functions | |||
| Vlookup won't work on these two particular spreadsheets | Excel Worksheet Functions | |||
| comparing two spreadsheets using vlookup and compare | Excel Worksheet Functions | |||
| using vlookup - how do I match 2 spreadsheets w/o same exact numb. | Excel Worksheet Functions | |||
Threaded Mode
