Thread
:
Pulling cell names from an associated cell
View Single Post
#
2
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_1642_]
external usenet poster
Posts: 1
Pulling cell names from an associated cell
If your Low Bid (minimum) is in cell AJ1, then...
=INDEX(AH1:AH17,MATCH(AJ1,AG1:AG17,0))
Rick
"Steve FTW" <Steve
wrote in message
...
I have a table where I am logging bid results
I am using the min(range) formula to transfer the low bid to another
worksheet in the book.
What would be the formula to transfer the name of the company (say it's in
the adjacent cell in the tabulation worksheet) to the other worksheet.
For Example:
Low Bid: =min(AG1:AG17)
Bidder: =???? (let's say bidder name in row AH)
Thanks!
Reply With Quote
Rick Rothstein \(MVP - VB\)[_1642_]
View Public Profile
Find all posts by Rick Rothstein \(MVP - VB\)[_1642_]