| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stock data manipulation | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| How do I use a conditional (IF) statement in Data Validation? | Excel Worksheet Functions | |||
| how to put data in the column A to the next row of the column B | Excel Discussion (Misc queries) | |||
Threaded Mode
