Help with a formula

[brubru24]

Hi,

I am trying to create a formula that brings back a month number based on where a value is input.

For example I have month 1 to 48 in column B from B1 to B40 and in column G1 to G40, I would place randomly the value 1000 aligned with Column B months for example months 1-13-19 etc. In column N I would like a dynamic formula that brings back the month number based on where I place the 1000s In Column G.

I can't attach my sample but I will ask the administrator. Once I figured out how

Thank you so much for your help in advance.

Bruno

 

[Andrew Poulsom]

Maybe:

=INDEX(B1:B40,MATCH(N1,G1:G40,FALSE))

 

[pe ken]

Sounds like a simple "IF" statement would work. In cell N1 put this formula: =IF(G1=1000,B1,"") then copy that down thru cell N40. Good luck!