• 0

Excel formula help needed


Question

Seems like an easy task but I keep getting error messages.

sheet1 has a list of unique numbers(e2:e2000) that are also listed on sheet2(b2:b20000), on sheet2 cell C2:c20000 there is a date.

I want to be able to match up the unique numbers on sheet1 and generate the corresponding date from sheet2

simple copy and paste cannot be done since everything is out of order and only 2000 numbers on sheet1 and 20,000 on sheet2.

I was using a basic vlookup but its def working or I get an error message. any help would be great.

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

What do you mean Vlookup is "def working"?

sorry, its def not working. getting a #vaule, I think im choosing the wrong range lookup or column index..

Link to comment
Share on other sites

  • 0

It sounds like you have two columns you need to compare then the result will display data from the third column? If so, a Vlookup/if statement should do the trick.

Link to comment
Share on other sites

  • 0

Do you simply want another column next to the values on Sheet 1 with the date, or do you want to find the unique values in Sheet 1 (values that only occur once) and return the date for those?

Edit: Sorry, re-read and I think I understand now. The vlookup should be:

=VLOOKUP(E2,Sheet2!$B$2:$C$20000,2)

Link to comment
Share on other sites

  • 0

Do you simply want another column next to the values on Sheet 1 with the date, or do you want to find the unique values in Sheet 1 (values that only occur once) and return the date for those?

Edit: Sorry, re-read and I think I understand now. The vlookup should be:

=VLOOKUP(E2,Sheet2!$B$2:$C$20000,2)

what worked, for some reason I thought I needed more info (such as column index). Thank you!!

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.