Hi Community,
I need to ability to create a lookup that returns the values of a cell if another cell value is blank in the same row.
The attached sheet shows the information I have (A-G), and the outcome I require (I-O).
Then have somewhere, a
If it is possible to function, I realise the values returned for the first blank cell will all be the same, but this isn't a problem as I will need to manually go through each to check other data.
Then I can add the allocation, which should then automatically trigger the references to change, as that will no longer be the first blank cell.
I thought it wouldn't have been so difficult to figure it out, but I'm stumped.
Thanks.
Bookmarks