Match Return Data

[morerockin]

Hello All,

Please see attached. Book2.xlsx

See Final Acceptance Tracker Tab. In Column B, I have the Site ID. In column L, I need it to match the site ID in column B on this sheet to Column C on the Daily Pass Fail report tab and return the status listed in column F IF Column D says "Pre Work".

See the Final Acceptance Tracker Tab. In column N, I need it to match the Site ID in column B on this sheet to Column C on the Daily Pass Fail report tab and return the date/time listed in Column I IF Column D says "Pre Work".

See the Final Acceptance Tracker Tab. In column R, I need to match the Site ID in column B on this sheet to Column Con the Daily Pass Fail report tab and return the status listed in column F IF Column D says "E Permanent Acceptance" OR "Permanent Acceptance".

Let me know if help is needed.

[morerockin]

Is there any clarification needed?


Sent from my iPhone using Tapatalk

[José Augusto]

use this array formula to get the values in L2

Please Login or Register  to view this content.

[morerockin]

Thank you Jose, but that only takes care a third of the problem. I still need to return values for Column N and Column R. Do you need further explanation?

[morerockin]

Can anyone else help?

[José Augusto]

See the file
Column L

Please Login or Register  to view this content.

Column N

Please Login or Register  to view this content.

Column R

Please Login or Register  to view this content.

If you think that the problem is solved you can flag it to SOLVED.

If you liked the resolution deems click * Add Reputation

[morerockin]

Jose,

This did not work for Column R as I have multiple items in column R that are in between 20-23 characters in length.

What do I do now?

[morerockin]

Anyone out there that can help?

[morerockin]

Hello All,


See Attached.Book2 (7).xlsx

If I change the naming convention in Columns B (Final Acceptance Tracker Sheet) and on Column C (Daily Pass - Fail Report), it will not return any data. Can someone please take a stab at this?

[morerockin]

Found the answer here:

http://www.excelforum.com/excel-gene...atch-help.html