View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tessa Tessa is offline
external usenet poster
 
Posts: 6
Default Return column header as solution to lookup

I want to search for the minimum value in each row and then return the column
header for the answer. For example:

FROM zip city QS SF PR

55001 AFTON 17.5 29.08 10.5 "answer"

Where the answer would be PR
I need this formula to copy down 178 rows as well. I have tried lookup,
hlookup and a few others, but cant seem to get it to work. Thanks in advance.