[SOLVED] Hi, I'm not very strong in Excel and am having difficulty creating a formula that does the following:
If a cell in a column is not blank, insert the number from the same row in column x
For example: If any cell in cells D7:D10 is not blank, insert the number in the same row in column C.
So, if searching D7:D10 finds content in D:8, insert the number here from C:8.
(Note: there will never be data in more than once cell in a column.)
Thank you in advance for any help you can provide.
Bookmarks