Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup from different sheets
hi,
I have the below data...like this i have huge data in different sheets(which are named date wise) and i can not consolidate them in a single sheet as the lines are more than 65000.The account numbers are repeting many a times in different sheets. In a consolidated sheets i have the unique account numbers where i want the name of the account holder... for this i need to use vlookup formula from alomost 20-22 sheets.is there any formula whereby i can use the vlookup from multiple sheets. Account Name 1245485 Stewart 4654546 Alex 2598545 Dean 1548777 Robert 4541112 David 1548477 Steve rgds radha |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup 3 sheets | Excel Worksheet Functions | |||
Vlookup using different sheets | Excel Discussion (Misc queries) | |||
Vlookup across several sheets | Excel Worksheet Functions | |||
vlookup in several sheets | Excel Worksheet Functions | |||
vlookup over 2 sheets? | Excel Worksheet Functions |