| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup and/or combing data from two worksheets
HELP! I have two worksheets. One is the Master Account list and the other is
the Aging. I have made it so both have the same column headings (Account, Name, Addresss, current, 7-30, 30-60 etc). What I need to do is combing the two so that the aging shows up on the Master in the row with the corresponding account. However, there are many more accounts on the Master than on the Aging so excel will need to look up or find the data. I have tried Vlookup but I cant get it to work. I feel like I am missing a crucial piece of info somewhere. Any help would be appreciated. Hopefully I am making sense. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i link data from closed worksheets without vlookup. | Excel Worksheet Functions | |||
| Combing Info. from multiple worksheets | Excel Discussion (Misc queries) | |||
| Combing months in ONE Cell | Excel Discussion (Misc queries) | |||
| Formula Help Combing two AND statements | Excel Worksheet Functions | |||
| Combing source data from 2 worksheets. | Charts and Charting in Excel | |||
Threaded Mode
