Hi all
I am looking for a Formula that would solve a problem like this:
=IF(BASE!BI:BI,1,LOOKUP(DAILY!G2,BASE!D:D,BASE!AV:AV
So I want to search for the value in DAILY!G2 in BASE!D:D and if found return the appropriate value from BASE!AV:AV to CELL BJ2 in DAILY!
ie If the IF requirement is...