Thread: HELP| populate cell with particular value based on multiple condit
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs
 
Posts: n/a
Default HELP| populate cell with particular value based on multiple condit

Try this formula in B1

=INDEX(E21:G21,MATCH(A1,{"Dog","Cat","Mouse"},0))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=511528

Reply With QuoteReply With Quote