I would like to add one more item to the formula below:
=IF(VLOOKUP(A2,'H:\000 Tracker\[PMWebRawData.xlsx]PMWeb'!$A;$IV,68,FALSE)="",IF(VLOOKUP(A2,'H:\000 Tracker\[PMWebRawData.xlsx]PMWeb'!$A:$IV,67,FALSE)="","",VLOOKUP(AA2,'H:\00= Tracker\[PMWebRawData.xlsx]PMWeb'!$A:$IV,67,FALSE)),VLOOKUP(A2,'H:\000 Tracker\[PMWebRawData.xlsx]PMWeb'!$A;$IV,68,FALSE))
What I would like to do is add a function that says, in this example that is in column AS, if the formula stops at column 67 because it's true then and an "X" in the next column to the right, which would be column AT in this instance.
Any suggestions?
=IF(VLOOKUP(A2,'H:\000 Tracker\[PMWebRawData.xlsx]PMWeb'!$A;$IV,68,FALSE)="",IF(VLOOKUP(A2,'H:\000 Tracker\[PMWebRawData.xlsx]PMWeb'!$A:$IV,67,FALSE)="","",VLOOKUP(AA2,'H:\00= Tracker\[PMWebRawData.xlsx]PMWeb'!$A:$IV,67,FALSE)),VLOOKUP(A2,'H:\000 Tracker\[PMWebRawData.xlsx]PMWeb'!$A;$IV,68,FALSE))
What I would like to do is add a function that says, in this example that is in column AS, if the formula stops at column 67 because it's true then and an "X" in the next column to the right, which would be column AT in this instance.
Any suggestions?