Hi, This is a simple MS excel data organize project. I have data in Column A, B, C, D. Values in Column A are unique, however, Values in Column B,C & D are pairs and need to stay together.I need a FORMULA to match the value from Column A with Column B, and align values from Column B,C & D in the same row. An example worksheet can be found at http://senduit.com/675465.Thank you in advance
Welcome back.
Will work on this in a short while and get back to you.
Hi, Let me know how it's coming.
Ok, here you go. Thanks to you for making it clear on that spreadsheet..
The formulas are in the blue cells.
FILE
Hope this is ok. Let me know if you have any questions.
Experience: Vast experience in Excel programming and business solutions
This is exactly what I was looking for, Thanks John. Another A+ solution.
Excellent! I am glad it worked :)