View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default If then formulas

=VLOOKUP(C1,A1:B51,2,FALSE)

--
Gary''s Student - gsnu200814