URGENT!!
I have a problem. I have a workbook called Business.xls and another workbook called Dbase_Customers.xls. The Dbase_Customers.xls file contains a list of customers with name, company name, phone#s, email, etc. I am trying to get a formula that with allow me to search the Dbase_Customers.xls file from the Business.xls file using the Customer ID#, Customer Name, or the Company and return values for the search for all of the customer info. I am trying to use the VLOOKUP function and nested if statements, but it does not want to seem to work. The search area also contains a validation list so if the person doin a search didn't know the customer name or id# they have a drop down list.
This is what I got so far:
=VLOOKUP((IF(B2>0,B2,F2)),Dbase_Customers.xls!$A$2:$N$3,1)
This works with just the Customer ID# field. I tried this with the other fields but it is saying NO to me
=IF(B2>0,(VLOOKUP(B2,Dbase_Customer.xls!$A$2:$N$3,1))),IF(C2=" ",(IF(D2=" ",,(VLOOKUP(D2,Dbase_Customers.xls!$A$2:$N$3,3)))),(VLOOKUP(C2,Dbase_Customers.xls!$A$2:$N$3,2)))
Most likely Im probably way off and there is a much easier way to do this. Im a newbie so any help is much appreciated. I think I just wrote alot of babble
Thanks
I have a problem. I have a workbook called Business.xls and another workbook called Dbase_Customers.xls. The Dbase_Customers.xls file contains a list of customers with name, company name, phone#s, email, etc. I am trying to get a formula that with allow me to search the Dbase_Customers.xls file from the Business.xls file using the Customer ID#, Customer Name, or the Company and return values for the search for all of the customer info. I am trying to use the VLOOKUP function and nested if statements, but it does not want to seem to work. The search area also contains a validation list so if the person doin a search didn't know the customer name or id# they have a drop down list.
This is what I got so far:
=VLOOKUP((IF(B2>0,B2,F2)),Dbase_Customers.xls!$A$2:$N$3,1)
This works with just the Customer ID# field. I tried this with the other fields but it is saying NO to me
=IF(B2>0,(VLOOKUP(B2,Dbase_Customer.xls!$A$2:$N$3,1))),IF(C2=" ",(IF(D2=" ",,(VLOOKUP(D2,Dbase_Customers.xls!$A$2:$N$3,3)))),(VLOOKUP(C2,Dbase_Customers.xls!$A$2:$N$3,2)))
Most likely Im probably way off and there is a much easier way to do this. Im a newbie so any help is much appreciated. I think I just wrote alot of babble
Thanks