Hi guys, please see the formula below... is there an alternative to entering in the col number so that when you drag the formula the col num increases each time?
=IF(VLOOKUP(C7,Overzicht!A8:L33,4,FALSE)=0,"",VLOOKUP(C7,Overzicht!A8:L33,4,FALSE))
Cheers for looking
Bookmarks