Hi,
Iam trying to work out the formula that goes with Vlookup..
This is what i want it to do,
I have tried this:
ALl help much appreciated.
Iam trying to work out the formula that goes with Vlookup..
This is what i want it to do,
. This works fine, however If the cell is blank i would like to reference another cell.VLOOKUP(D145,Schedule!$C$3:$E$129,3,FALSE))&" PM"
I have tried this:
, however it keeps returning a value of 0 even though the cell is empty.IFERROR(VLOOKUP(D145,Schedule!$A$3:$D$129,4,FALSE),VLOOKUP('Weekly Activity'!D145,Schedule!$A$3:$J$1294,10,FALSE))&"PM"
ALl help much appreciated.