Hi,
I am trying to create a formula that reads:
If cell "b99" is blank, then leave it blank, otherwise, look up cell "b99" in the defined range of "Acct_budget_lookup,give me the value in column 11, for an exact match.
My formula (which isn't working) is:
=if(b99,"","",VLOOKUP($B99,Acct_budget_lookup,11,FALSE))
Could anyone tell me what I am doing wrong?
Thanks
Darcy
I am trying to create a formula that reads:
If cell "b99" is blank, then leave it blank, otherwise, look up cell "b99" in the defined range of "Acct_budget_lookup,give me the value in column 11, for an exact match.
My formula (which isn't working) is:
=if(b99,"","",VLOOKUP($B99,Acct_budget_lookup,11,FALSE))
Could anyone tell me what I am doing wrong?
Thanks
Darcy