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