Function for checking a cell and if it holds text "N/A" move right to next cell

[jackson1990]

Hey everyone!

I'm working through a little but of an issue. Trying to think of a way to write a function that will cause it to check the cell to the right of it and if it has "N/A" to skip that cell and move to the cell to the right of it check that cell if it has N/A then move to the right, until it finds one that actually has a date in it.

How it is set up as follows: Someone puts in a final date (when it needs to be finished by) this is manually entered. We'll just use and example here of 5/15/2018. I think use a mix of a if,sum, and vlookup in the cell to the left of it to minus days off for the milestone before that (say the mile stone before final date is like editing) so to the left of the final date I have this function.

=IF(SUM(AC2-VLOOKUP($L$2,Table1[#All],COLUMN()-20,FALSE))=AC2,"N/A",SUM(AC2-VLOOKUP($L$2,Table1[#All],COLUMN()-20,FALSE)))

AC2 is the final date, it vlookups to a table with a bunch of numbers, finds the right number to minus off, brings it back and minuses that number of days off. It also is checking to see if the cell to the right and this current cell are equal (as in having the same date), and if they are it puts N/A in the cell.

What I want to be able to do is for it to check "AC2" (in this case) to see if it is N/A, if it is N/A then I want it to skip to the cell to the right of it, as many times as it has to till it finds a date. Is this possible?

Thanks in advance!!!

 

[jackson1990]

Thanks Aladin! I made some changes to how my spreadsheet worked, but it was your logic that helped me solve it! So, thank you for working through it with me.

 

[Aladin Akyurek]

Thanks Aladin! I made some changes to how my spreadsheet worked, but it was your logic that helped me solve it! So, thank you for working through it with me.

You are welcome.