Oct 15 2021 12:59 PM
I need help determining the proper function if one exists.
I am comparing 2 different cells to determine a number to place in another cell.
The basis is:
IF c2="NIL" and d2="ASCUS" then "1/2" should be in e2 OR
IF c2="NIL" and d2="LSIL" then "1" should be in e2 OR
IF c2="NIL" and d2="HSIL" then "2" should be in e2.
There are multiple other comparison I want to make also. So maybe 6 different comparisons in e2.
Thanks.
Oct 15 2021 01:10 PM
I'd create a small lookup table. In the screenshot below, it is in H2:I7.
The formula in E2 is
=IF(C2="NIL",VLOOKUP(D2,$H$2:$I$7,2,FALSE),"")
Oct 15 2021 01:47 PM
Oct 15 2021 02:48 PM
SolutionOct 15 2021 02:48 PM
SolutionI'd use a two-dimensional lookup table:
See the attached sample workbook.