| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pulling cell names from an associated cell
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pulling cell names from an associated cell
Thank you
"Rick Rothstein (MVP - VB)" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling data from a cell in between / | Excel Worksheet Functions | |||
| Pulling cell value into macro | Excel Programming | |||
| Pulling text from a cell | Excel Worksheet Functions | |||
| Pulling a Letter from a cell and filling another cell with info | Excel Worksheet Functions | |||
| pulling certain data out of a cell | Excel Worksheet Functions | |||
Linear Mode
