Thread: HLookup?
View Single Post
  #1  
Old June 1st, 2010, 05:55 PM posted to microsoft.public.excel.worksheet.functions
wagz
external usenet poster
 
Posts: 5
Default HLookup?

I have a sheet that is comparing vendor's pricing. I am using the MIN to
find the cheapest cost, but now I want to find out which vendor it is based
on the cost. The vendor's name is across the top of the columns and the MIN
price is found in the column to the right of all the prices. The value I
want in the end it the vendor's name who has the cheapest cost for that row.

Any help is appreciated!

-EW