Excel: Find Name with an ID number, VLOOKUP FUNTION!

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