jerzdawg Posted March 29, 2012 Share Posted March 29, 2012 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 More sharing options...
0 bdsams Veteran Posted March 29, 2012 Veteran Share Posted March 29, 2012 What do you mean Vlookup is "def working"? Link to comment Share on other sites More sharing options...
0 jerzdawg Posted March 29, 2012 Author Share Posted March 29, 2012 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 More sharing options...
0 bdsams Veteran Posted March 29, 2012 Veteran Share Posted March 29, 2012 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 More sharing options...
0 laycat Posted March 29, 2012 Share Posted March 29, 2012 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 More sharing options...
0 jerzdawg Posted March 29, 2012 Author Share Posted March 29, 2012 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 More sharing options...
Question
jerzdawg
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