Hi Dakota,

Am Fri, 9 Oct 2015 09:48:05 -0700 (PDT) schrieb dakota park:

I ended up getting the following formula to work, but was still curious as to whether or not there is an easier way to write this formula - (excel noobie)

=IFERROR(IFERROR(IFERROR(IFERROR(IFERROR(IF(MATCH( B2,Categories!A:A,0)<"#N/A","LOW"),(IF(MATCH(B2,Categories!B:B,0)<"#N/A","MIDDLE"))),(IF(MATCH(B2,Categories!C:C,0)< "#N/A","MODERATE"))),(IF(MATCH(B2,Categories!D:D,0)<" #N/A","UPPER"))),(IF(MATCH(B2,Categories!E:E,0)<" #N/A","UNKNOWN"))),"")

you have answers in group
microsoft.public.excel.programming

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional