Hi all,
Looking for formula help....
I have 2 large data sheets. They contain overlapping data, and different data. I need to add a new column P in DataSheet A (DSA) which will return a value found in Data Sheet B (DSB)
So I want the exact data combo found in DSA cells C2, D2 and L2 to then try and find a matching combination in DSB by looking in columns E, J and M.
If the values found in DSA C2, D2 and L2 find matching combination in DSB columns E, J and M....THEN return value in DSB matching row column A to DSB column P2.
I hope this makes sense. It's a bit hard to explain.
I've added a demo excel to make it clearer hopefully. See attached.
Thanks!
Bookmarks