Hello All,
Please see attached and below formula.
=IFERROR(INDEX(REPORT!$P:$P,MATCH(B2&"PO700AAS"&F2,REPORT!$B:$B&REPORT!$I:$I&REPORT!$H:$H,0)),"")
Here is what the formula is doing.
- Indexing column P on the Report tab
- Matches the ID column in both reports
- Matches the string "PO700AAS" with column I on the report tab
- Matches the Comp column on both tab
Here is what I need it to do
- Instead of matching the string "PO700AAS" with column I on the Report tab, it needs to do an If Statement
- The IF formula needs to look at the job in column D of the Tracker Tab and use the following logic
- If the job in column D of the tracker tab is 700, the formula should look for "PO700AAS" in column I of the report tab
- If the job in column D of the tracker tab is 1900, the formula should look for "PO1900AAS" in column I of the report tab
- If the job in column D of the tracker tab is 2100, the formula should look for "PO2100LAB" in column I of the report tab
Let me know if this does not make sense.
Bookmarks