Hi,
I am trying to lookup a table array and if the value is not found, replace the selected cell with a certain value:
=VLOOKUP(B392,Lookup!$A$2:$B$19,2,FALSE) – Replace B392
The above is not working, any suggestions on how I can do this?
Thanks,
Ruth
I am trying to lookup a table array and if the value is not found, replace the selected cell with a certain value:
=VLOOKUP(B392,Lookup!$A$2:$B$19,2,FALSE) – Replace B392
The above is not working, any suggestions on how I can do this?
Thanks,
Ruth