Need formula help to compare 2 data sheets and extract cell value

[m_roussakis]

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!

[bob33]

Send a mock up file with dummy data. Be easier to follow and help IMO.

[m_roussakis]

Send a mock up file with dummy data. Be easier to follow and help IMO.

Just did that. check original post. thx

[JeteMc]

Try pasting the following into cell P2 on Sheet A:

Please Login or Register  to view this content.

Let us know if you have any questions.