SOLVED

Feels like this should be simple?

Copper Contributor

Screen Shot 2018-04-26 at 15.11.31.png

 

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 it looks like this:

 

Screen Shot 2018-04-26 at 15.25.41.png

The values in B5 and C5 will change in subsequent rows.

 

I have been trying things for days now and am pulling out my hair, it seems like it should be simple?

 

Any help appreciated.

 

Reagrds

 

Nigel

 

 

3 Replies
best response confirmed by Jamil Mohammad (Bronze Contributor)
Solution

please see attached

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!

You are welcome. Thanks for the feedback.
1 best response

Accepted Solutions
best response confirmed by Jamil Mohammad (Bronze Contributor)
Solution

please see attached

View solution in original post