I want to search a7:a21 to see if the number 1 is in any of those cells, if true then I want to copy cell b in that row to another cell somewhere else.
in example supplied i want cell b8 copied to b2 because cell a8 has the number 1 in it.
I want to search a7:a21 to see if the number 1 is in any of those cells, if true then I want to copy cell b in that row to another cell somewhere else.
in example supplied i want cell b8 copied to b2 because cell a8 has the number 1 in it.
Edited. Circular reference error in previous formula.Formula:Please Login or Register to view this content.
Last edited by FlameRetired; 10-23-2018 at 11:21 PM.
Dave
that worked, thank you so much.
how to i mark this post solved
You are welcome. Glad to help, and thank you for marking your thread Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks