Hiya,

To do the formula as you've got it, try...

=IF($E$3="Wg Missing",0,VLOOKUP($B$2,FEB!$A$14:$CH$43,7))

Or, if you wanted to dispense with the additional formula that you've got in column E and do it in one go, try...

=IF($B$2<>E$264,0,VLOOKUP($B$2,FEB!$A$14:$CH$43,7))

Rgds

AJ

## Like this thread? Share it with others