Hi, I am new to forums
I know this already been asked but I still newbie and can't understand how to modify it to my situation.
I look into these thread but only understand some of the concept.
http://www.mrexcel.com/forum/excel-questions/231882-vlookup-return-all-matches.html
http://www.mrexcel.com/forum/excel-questions/395345-lookup-returns-multiple-values.html
http://www.mrexcel.com/forum/excel-questions/362743-vlookup-duplicates.html
Here is my sample, please take a look.
LookupSample.xlsx
Currently in sheet SOs column B, I using vlookup, which obviously does not work.
I want to return multiple values not just the first one that found.
For example, B3 should return SO560700167 :06/07/2013 instead of SO560700288 :10/07/2013
If someone would provide me an exact formula, I would be very appreciated.
<tbody>
</tbody>
I know this already been asked but I still newbie and can't understand how to modify it to my situation.
I look into these thread but only understand some of the concept.
http://www.mrexcel.com/forum/excel-questions/231882-vlookup-return-all-matches.html
http://www.mrexcel.com/forum/excel-questions/395345-lookup-returns-multiple-values.html
http://www.mrexcel.com/forum/excel-questions/362743-vlookup-duplicates.html
Here is my sample, please take a look.
LookupSample.xlsx
Currently in sheet SOs column B, I using vlookup, which obviously does not work.
I want to return multiple values not just the first one that found.
For example, B3 should return SO560700167 :06/07/2013 instead of SO560700288 :10/07/2013
If someone would provide me an exact formula, I would be very appreciated.
<tbody>
</tbody>