Apr 26 2018
07:29 AM
- last edited on
Jul 25 2018
11:50 AM
by
TechCommunityAP
Apr 26 2018
07:29 AM
- last edited on
Jul 25 2018
11:50 AM
by
TechCommunityAP
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:
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
Apr 26 2018 07:37 AM
Solutionplease see attached
Apr 26 2018 08:58 AM
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!
Jun 16 2018 12:53 PM
Apr 26 2018 07:37 AM
Solutionplease see attached