Thread
:
HLookup?
View Single Post
#
2
June 1st, 2010, 06:20 PM posted to microsoft.public.excel.worksheet.functions
DILipandey[_2_]
external usenet poster
Posts: 16
HLookup?
Hi, I think it can be solved using offset & index match functions. If
possible, provide the sample data.
--
Click on Yes, if it is useful.
Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
+91 9810929744
New Delhi, India
"wagz" wrote:
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
DILipandey[_2_]
View Public Profile
View message headers
Find all posts by DILipandey[_2_]
Find all threads started by DILipandey[_2_]