vlookup for more than 2 range

[hitesh]

dear

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

regards

anil

 

[Stefi]

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


„hitesh†ezt írta:

 

[hitesh]

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]

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:

 

[Ragdyer]

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))

 

[hitesh]

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]

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 !
-----------------------------------------------------------------------------------------------

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

pls help