Forum Discussion

Nigel Dawson's avatar
Nigel Dawson
Copper Contributor
Apr 26, 2018
Solved

Feels like this should be simple?

  In the above example I want to lookup B5 and insert into col 4 (G) the value in A5 - that was easy enough but then I need it to populate cols up to the col in C5 with the same value (A5) so...
Formulas & Functions
Need Help
Jamil's avatar
Jamil
Bronze Contributor
Apr 26, 2018

please see attached

  • Nigel Dawson's avatar
    Nigel Dawson
    Copper Contributor
    Apr 26, 2018

    Thanks for that. Frustratingly, I'm sure I did that but obviously made a mistake somewhere but at least I was on the AND OR path.

     

    Any, much appreciated. I'll sleep tonight!

    • Jamil's avatar
      Jamil
      Bronze Contributor
      Jun 16, 2018
      You are welcome. Thanks for the feedback.

Resources