Posted: 2/22/2013 6:30:47 AM EDT
I have two sheets sort of these, with Data-A and Data-B in sheet 1 and Data-A and Data-C in sheet 2:
What can I put in sheet 2 col c to get the corresponding Data-B from sheet 1? In other words, I want:
Any ideas? Hopefully I explained it well enough. Is there a way to do something like Sheet 2 Row A Col 3 = Sheet 1 Row X Col 2 if Sheet 1 Row x Col A == Sheet 2 Row A Col 1? |
|
Use the VLOOKUP function. Check the help. There are some good examples there.
One thing to know, is that it will return the FIRST match it finds in the column where it is looking for a match. So that means if you have two "Jill's " in then list, it will only return the match from the first. You need to make a unique value to match against. JillC and JillM as an example. |
|
Awesome! That looks like just what I needed. There should be plenty of documentation to take care of the rest.
I've already eliminated duplicate rows based on Data-A, so if they had associated non-duplicate Data-B values, that's already been lost.  Shouldn't be a problem though, if it turns out that I need it, I still have a master list with everything in it.
Thanks again! |