R
raehippychick
I have a inherited a spreadsheet with formulae in it - this one gives m
a number in column B which is great but I would like to add something t
it so that it also looks at column P and if column P does *not* have th
word "Unrefreshed" the formula below will return a value of zero
=IF(ISBLANK(G30),"",VLOOKUP(G30,MachineData,3,FALSE))
Many thanks in advanc
a number in column B which is great but I would like to add something t
it so that it also looks at column P and if column P does *not* have th
word "Unrefreshed" the formula below will return a value of zero
=IF(ISBLANK(G30),"",VLOOKUP(G30,MachineData,3,FALSE))
Many thanks in advanc