If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 | |
Display Modes | |
|
|