Looking up previous data in column within an IF statement
 

Hi,

Im trying to lookup data in a column that is not necessarily the last
piece of data.

eg, I have data in column a where an exact phrase turns up from doing
some if calculations. I want this exact phrase to be looked up so that
I can then vlookup or other to bring back an exact match. In the below
I would be looking to add to my IF statement that project detail will
be replaced by the most previous project name cell data, so if these
were all in column a, I would want b1 to appear in all the product
detail cells.

The current formulae that I am using in column a is =IF(C41="Project
RAG [Notes]","",(IF(C41="","<BLANK",(IF(A42="","Project Name","Project
Detail"))))) where I will replace the Project detail with the lookup
query for the latest project name data??

Project Name

Project Detail
Project Detail
Project Detail
Project Detail
Project Detail
Project Detail
Project Detail
Project Detail
Project Detail

Is there a way that this can be carried out simply?? Cheers, Dan