Most valuable professional
  • Hot Topics

Excel Find Name with an ID number, VLOOKUP Function!

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 (their is two sheet of customer data, one is residential and the other one is commercial data)

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:

  • Excel
  • Microsoft Excel