Thread: Help with Excel Formula (Multiple Vlookups in an If Statement"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
dakota park dakota park is offline
external usenet poster
  
Posts: 8
Default Help with Excel Formula (Multiple Vlookups in an If Statement"
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"))),"")
Reply With QuoteReply With Quote