May 12 2020 09:03 AM
Greetings, I'm stuck on a difficult need that I know MS Excel can deliver, but I'm not the excel wizard that many here are, so I'm grateful for any insight or advice you can give.
Desired Workflow with example cells:
Basically I'm making a form that will identify risky behaviors while users enter the requests based on a table instead of static values, and then return any warnings from the table in another cell on the same row.
Again, I greatly appreciate any assistance you can provide, and thank you for taking the time out to help others.
May 12 2020 10:32 AM
@Matt Johnson try below:
=IF(ISERROR(VLOOKUP(A2,tbl_warnings,1,FALSE)),
IF(ISERROR(VLOOKUP(F2,tbl_warnings,1,FALSE)),"",VLOOKUP(F2,tbl_warnings,2,FALSE)),
VLOOKUP(A2,tbl_warnings,2,FALSE))