SOLVED
Home

Feels like this should be simple?

Nigel Dawson
New 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
Highlighted
Solution

please see attached

Highlighted

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!

Highlighted
You are welcome. Thanks for the feedback.
Related Conversations
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies