David Montoya
New Member
- Joined
- Apr 25, 2018
- Messages
- 49
Dear,
I have the following issue, and looking for possible assistance.
The formula I currently have is broken into three pieces:
It has been working perfect; however, I need to introduce a new condition; the options on numeral 3 above are changing to "A", "A+", "A*", "C A", "C A+", or "C A*"
Now if the 2nd step above stops the process, I need to look into the new options, and if the result contains a "C" regardless of the combination, I need to give a final result as "C" even if the separate table column E:E, and a concatenation of active workbook cells D4 and G4 the result is other than ">0", which normally provide me an empty cell result.
The following formula is in cell AM4:
I have tried to first work the new condition by itself; it works, but it gives me a "FALSE" result, and the desired is to leave the target cell blank:
After combining the previous formula with the new condition; still giving me a "FALSE" result, and the desired is to leave the target cell blank if the conditions are not within "A", "A+", "A*", or "C" for any other combination:
Thanks in advance for any assistance you can provide.
I have the following issue, and looking for possible assistance.
The formula I currently have is broken into three pieces:
- It looks at cell A4 if empty, otherwise to process the second part...
- It looks if a separate table column E:E contents, and compare with a concatenation of active workbook cells D4 and G4, if the result is other than ">0", it continuous with step 3, otherwise, it stops any further process and leaving the target cell empty. If the result is =0, then the formula...
- It looks if the content of the active workbook cells D4 appears on a separate table, giving the found information if available, otherwise leaving the target cell empty. At this step, if it finds the target, it gives back any results from "A", "A+", or "A*"
It has been working perfect; however, I need to introduce a new condition; the options on numeral 3 above are changing to "A", "A+", "A*", "C A", "C A+", or "C A*"
Now if the 2nd step above stops the process, I need to look into the new options, and if the result contains a "C" regardless of the combination, I need to give a final result as "C" even if the separate table column E:E, and a concatenation of active workbook cells D4 and G4 the result is other than ">0", which normally provide me an empty cell result.
The following formula is in cell AM4:
Code:
=IF(A4="","",IF(COUNTIF('SPI by HTS'!E:E,"*"&'Master Query'!D4&'Master Query'!G4&"*")>0,"",IFERROR(VLOOKUP(D4,'SPI by HTS'!A:B,2,0),"")))
I have tried to first work the new condition by itself; it works, but it gives me a "FALSE" result, and the desired is to leave the target cell blank:
Code:
=IF($A4="","",IFERROR(IF(VLOOKUP(D4,'SPI by HTS'!A:B,2,0)="C A*","C",IF(VLOOKUP(D4,'SPI by HTS'!A:B,2,0)="C A","C",IF(VLOOKUP(D4,'SPI by HTS'!A:B,2,0)="C A+","C"))),""))
After combining the previous formula with the new condition; still giving me a "FALSE" result, and the desired is to leave the target cell blank if the conditions are not within "A", "A+", "A*", or "C" for any other combination:
Code:
=IF(A4="","",IFERROR(IF(VLOOKUP(D4,'SPI by HTS'!A:B,2,0)="C A*","C",IF(VLOOKUP(D4,'SPI by HTS'!A:B,2,0)="C A","C",IF(VLOOKUP(D4,'SPI by HTS'!A:B,2,0)="C A+","C"))),IF(COUNTIF('SPI by HTS'!E:E,"*"&'Master Query'!D4&'Master Query'!G4&"*")>0,"",IFERROR(VLOOKUP(D4,'SPI by HTS'!A:B,2,0),""))))
Thanks in advance for any assistance you can provide.