Formula for a cell number

[GetPaidOl9]

Hello Friends,

I have a huge spreadsheet with 18 columns and >2000 rows. In column 'N' there is data that change by changing the data in columns 'C', 'D', 'E' and 'G'. On the top of column 'N', I have put the the formula "=MIN(N10:N2087)". I get the ans correctly, but can I get the cell number (in the adjacent cell) which contains that minimum values. I don't want to scroll whole sheet every time when the cell number changes.

Thanks in advance.

 

[Special-K99]

Attach a sample spreadsheet, remove any sensitive data.

You cant attach files on this forum.
Upload the file to an online storage site then place a link to it on this forum.

 

[GetPaidOl9]

Sorry, I am late. I have uploaded the image of a sample file to imgur, the link is - http://i.imgur.com/00IkG2A.jpg
I have put what I want. Can this is possible? Is there any formula for such?

Please tell me a good online storage site to upload file(s). Sorry, I don't know.

 

[jarjarbingie]

try:

=OFFSET(A9,MATCH(MIN(N10:N2087),N10:N2087,0),0)

Sorry, I am late. I have uploaded the image of a sample file to imgur, the link is - http://i.imgur.com/00IkG2A.jpg
I have put what I want. Can this is possible? Is there any formula for such?

Please tell me a good online storage site to upload file(s). Sorry, I don't know.

 

[GetPaidOl9]

try:

=OFFSET(A9,MATCH(MIN(N10:N2087),N10:N2087,0),0)

I may be wrong some where, but this gives me the value in 'A10' only. Can you please explain me what I am missing?

 

[jarjarbingie]

can you post a screenshot?

I may be wrong some where, but this gives me the value in 'A10' only. Can you please explain me what I am missing?

 

[GetPaidOl9]

Done. I copy pasted your formula and done. Screenshot here - Imgur.

Thank you very much.

 

[GetPaidOl9]

Sorry friend,

Though I copy-pasted, not working for another file. Screenshot - Imgur Please help.

 

[jarjarbingie]

hmmm, what the formula does is it looks for the first instance of the MIN value in the range N10:N2087, then return the corresponding value from column A.. could it be that there are duplicates in column N? or maybe you have to change the column from N to R?

Sorry friend,

Though I copy-pasted, not working for another file. Screenshot - Imgur Please help.

 

[galt13]

Try this

=ADDRESS(MATCH(N1,N10:N2087,0)+9,14,4)