Good Day, Good People
I'm having some troubles writing the proper formula for my data
Basically, I'll fetch the data from one sheet (RAW) to another main work area (IIIE), but there's some error
Here's my goal:
First, check if the corresponding value on RAW is greater than 0 (if not, print the string "OUT")
Next, check if the character "*G*" is on its corresponding header; if yes, print "HIT"
Meanwhile, if the character "*F*" is on the corresponding header, print "FALSE"
If neither G nor F is there, print "ERROR"
This is the formula that I wrote, but it throws an error, and I can't seem to find where the mistake is
I also attached the Excel file
Hope you can lend me some help quickly
Thanks,
Ash
P.S. I can't show the full thing since a screenshot is limited, but it's essentially the same
I'm having some troubles writing the proper formula for my data
Basically, I'll fetch the data from one sheet (RAW) to another main work area (IIIE), but there's some error
Here's my goal:
First, check if the corresponding value on RAW is greater than 0 (if not, print the string "OUT")
Next, check if the character "*G*" is on its corresponding header; if yes, print "HIT"
Meanwhile, if the character "*F*" is on the corresponding header, print "FALSE"
If neither G nor F is there, print "ERROR"
This is the formula that I wrote, but it throws an error, and I can't seem to find where the mistake is
IF((INDEX(RAW!$B$3:$B$75,MATCH([@ID],[ID],0)))>0,IF(TableIIIE[[#Headers],[AG1]:[BG15]])="*G*","HIT",IF(TableIIIE[[#Headers],[AG1]:[BG15]])="*F*","FALSE","ERROR")),"OUT"))
I also attached the Excel file
Hope you can lend me some help quickly
Thanks,
Ash
P.S. I can't show the full thing since a screenshot is limited, but it's essentially the same