Index / match

[leopardhawk]

Trying to create a formula that will search column B for the number 69 and return the corresponding value from the same row in column G.

Having a brain cramp.

Thanks for any assistance!

 

[Fluff]

Re: need help with INDEX / MATCH

How about
=IFERROR(INDEX($F$16:$F$100,MATCH(69,$B$16:$B$100,0)),F16)

 

[leopardhawk]

Fluff, brilliant! Thank you so much for your advice and efforts.

 

[Fluff]

You're welcome & thanks for the feedback