dear

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

regards

anil

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

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

Your data being in columns A,B,C of Sheet2, enter this formula in sheet1 cell
B2 for Customer
=VLOOKUP(A2,Sheet2!A:B,2,FALSE)

and in C2 for Address
=VLOOKUP(A2,Sheet2!A:C,3,FALSE)

Regards,
Stefi


€žhitesh€� ezt Ã*rta:

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

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

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

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