SOLVED
Home

Feels like this should be simple?

Highlighted
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
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.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies