Thread: Finding an item in a list & returning a specific value
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
klswvu[_2_] klswvu[_2_] is offline
external usenet poster
  
Posts: 27
Default Finding an item in a list & returning a specific value
=INDEX(Sheet2!$A$1:$B$16,MATCH(L1,Sheet2!$A$1:$A$1 6,0),2)

Returns #N/A if part not found... use the standard ISERROR and IF around the
formula.
Reply With QuoteReply With Quote