Formula to Associate Number to Name in another sheet

I have a sheet (Contacts) with my customer contacts in it and a separate sheet (Customers) with my customer companies in it.  The “Contacts” do not have the company name, but they have a “custID” number which matches a column in the “Customers” sheet.  

is there a way to make a formula to say if custID is 2587 then “Name” is XXX based on a lookup from the columns on the other sheet.

By: Steve

4 thoughts on “Formula to Associate Number to Name in another sheet

  1. James

    Use VLOOKUP as follows;
    -custID1 is the id no.s for contacts’ sheet
    -Area2! is the other array of the sheet where to check the company names!
    -Company Name should be the column where to pick the co. names


    Pretty nice post. I just stumbled upon your weblog and wished
    to say that I’ve really enjoyed surfing around
    your blog posts. In any case I will be subscribing
    to your rss feed and I hope you write again soon!

Leave a Reply

Your email address will not be published. Required fields are marked *