This is what I have so far.
=IF(ISNA(VLOOKUP(H61,Estimates!AT:AT,1,FALSE))=TRUE,"Case not found",VLOOKUP(H61,Estimates!AT:AT,1,FALSE))
This returns the project ID if found and "Case not found" if it isn't (I also added a conditinal formatting rule to fill Case not Found cells red. I've now been asked to also look for anything is in the notes column and keep the formula from returning Case not found in the rows below the data. I need to add a IF AND to look for the number and for notes in the Notes column and return the project ID in those cases. The source data is a working spreadsheet that is add to daily. I recorded a macro to format and insert the formula, but I can't get it to not show a value if nothing is available for lookup. I've used a formula before that returns nothing on blanks, but can't remeber how I did it. I'm also getting back into this after not writing a formula for 3-4 years so I'm struggling and trying to piece together form old work.
Bookmarks