this is what I'm trying to do:
search a row for a MINimum value; then return the contents of a cell (which is text) from the column where the minimum was found.
I thought at first HLOOKUP would be it, but I guess that will only return numerical data.
thanks for any help.
-Cotter
Hi Cotter,
Welcome to the forum.
This would require combining one or more functions. If you could upload a sample workbook someone will be able to resolve.
To upload workbook, click on "Go Advanced" and select "Attachments"
Thanks,
If solved kindly remember to mark Thread as solved.
Click the small star icon at the bottom left of my post if this was useful.
thanks for the response, I have attached a greatly simplified version of my worksheet, with explanation included.
thanks again.
Hi Cotter
Try: =INDEX(C3:H3,,MATCH(MIN(C6:H6),C6:H6,0))
Use this in L3:
Formula:
Please Login or Register to view this content.
Hope this helps...
write at L3
=INDEX($C$3:$H$3;MATCH(MIN($C$6:$H$6);$C$6:$H$6;0))
Thanks to all of you, that worked!!!
-Cotter
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks