Looking up previous data in column within an IF statement

C

CheekyFlash

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge query 1
Sum cells using criteria from a row and a column 2
Sum every 6th cell in a row. 3
Complex SUMPRODUCT/VLOOKUP/SUMIF 1
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
IF function 3
Looking up a value in a list & returning multiple corresponding va 3
Using Table Column Data in MATCH 1

Top