LOOKUP questions

Hi all, I am trying to incorporate LOOKUP formula and had few questions:

1) The current formula I have utalizes 2 variables, could this be expanded to 3?

Please Login or Register  to view this content.

the current formula I have seems to return numbers only? as the text that I want to be returned gets returned as 0

3) finally, I would like to incorporate it so the formula skipps any non blanks. I have below that I use, but everytime I tried to incorporate this, it wouldnt work..I have bits and pieces of everything and was looking for some help to piece it together.. when i try to run below I get Compile error "Invalid or unqualified Reference" under below red text

Please Login or Register  to view this content.

=LOOKUP(REPT("Z",255),IF({1,0},"",LOOKUP(2,1/(A4='previous day'!A$2:A$19)/(H4='previous day'!H$2:H$19),'previous day'!M$2:M$19)))

will work for text.

In code it would need to double up the quotes

Please Login or Register  to view this content.