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