I have a upcoming appointment that after i type the CUSTOMER ID I want to find the customer name automatically. use this formula =IF(NOT(ISNA(VLOOKUP(D7,Customer_Data,1,0))),VLOOKUP(D7,Customer_Data,1,0), IF(NOT(ISNA(VLOOKUP(D7,Commercial_Data,1,0))), VLOOKUP(D7,Commercial_Data,1,0), "")) but is not working plus i have some screen shots here for better understanding http://snag.gy/PT8Tz.jpg (their is two sheet of customer data, one is residential and the other one is commercial data) http://snag.gy/b1LDr.jpg
This question generated 10 answers. To proceed to the answers, click here.
This thread is current as of October 16, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel