What's wrong with something like this:
=IF(COUNTIF(B1:B100,A1),"high",IF(COUNTIF(C1:C100,A1),"medium",IF(COUNTIF(D1:D100,A1),"low","")))
What's wrong with something like this:
=IF(COUNTIF(B1:B100,A1),"high",IF(COUNTIF(C1:C100,A1),"medium",IF(COUNTIF(D1:D100,A1),"low","")))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks