Forum Discussion

Tony2021

Iron Contributor

Mar 12, 2022

Solved

IF Statement help. If Null return Null

Hello, if A11 is null then how could I return nothing (meaning nothing in the cell..ie null). In the below, if A11 is null then it returns "Not In a DD" =IF(ISNA(VLOOKUP(A11&B11&C11,ProjectCosts...

excel

houghtonap
Mar 17, 2022
Yup, that changes things.

=IF(TRIM(CLEAN(A11))="","",IF(ISNA(VLOOKUP(A11&B11&C11,ProjectCostsPQ_FE.xlsx!Project_Costs[[#All],[Vendor]]&ProjectCostsPQ_FE.xlsx!Project_Costs[[#All],[Invoice '#]]&ProjectCostsPQ_FE.xlsx!Project_Costs[[#All],[Invoice amount]],1,FALSE)),"NOT IN a DD","In Previous DD"))

Tony2021

Iron Contributor

Mar 16, 2022

Hi Hough, sorry for my tardy reply.

I might have to explained it well enough.
If A11 is blank then return a Blank. I do not want to return "NOT IN a DD","In Previous DD"...just return "".

does that change anything? thank you for the help.

houghtonap

Copper Contributor

Mar 17, 2022

Yup, that changes things.

=IF(TRIM(CLEAN(A11))="","",IF(ISNA(VLOOKUP(A11&B11&C11,ProjectCostsPQ_FE.xlsx!Project_Costs[[#All],[Vendor]]&ProjectCostsPQ_FE.xlsx!Project_Costs[[#All],[Invoice '#]]&ProjectCostsPQ_FE.xlsx!Project_Costs[[#All],[Invoice amount]],1,FALSE)),"NOT IN a DD","In Previous DD"))

Tony2021
Iron Contributor
Mar 17, 2022
Nice. thank you very much! Works perfectly.