vlookup for more than 2 range

  • Thread starter Thread starter hitesh
  • Start date Start date
H

hitesh

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
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
 
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:
 
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))
 
dear,
my date base is in 4 sheets,your formula work only for 2 sheets.
i want the formula for 4 sheets.

pls help
 
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
 
Back
Top