With the capacity of 65,000 rows for each sheet, why can't you combine your
4 sheets into 2?

It'll make your life *much* easier and simpler.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"hitesh" wrote in message
...
dear,
my date base is in 4 sheets,your formula work only for 2 sheets.
i want the formula for 4 sheets.

pls help

"Ragdyer" wrote:

With data on Sheet1 and Sheet2, try this in B2 of your third sheet,
where A2 holds the invoice you're looking for:

=IF(ISNA(MATCH(A2,Sheet1!A2:A100,0)),VLOOKUP(
A2,Sheet2!A2:B100,2,0),VLOOKUP(A2,Sheet1!A2:B100,2 ,0))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"hitesh" wrote in message
...
dear
stefi

i have big databse, i maken a two sheet.

1st column is for invoice no , 2nd column for customer name, and 3rd
column
for address, this data is in both sheet.

whenever customer pay the invice amount, i just type the invoce no and
the
customer name appear,i used the vlookup formula for one sheet, but its
not
work if data is in 2 sheet. some inovice no is in 2 sheet.

so pls help.

regards
anil

"Stefi" wrote:

Please give more details of your data structure and what do you want
to
lookup!
Stefi


"hitesh" ezt írta:

dear

i have a database in 2 sheet, and i want to use vlookup in 3rd
sheet,
pls help its urgent.

regards

anil