claire_pike
New Member
- Joined
- Aug 10, 2006
- Messages
- 40
Hi,
Can you help me with my formula....
=IF(VLOOKUP(A2,Master!E$3:P$1805,12,FALSE)=L$1,"864","0")
That's the basic formula but I often have multiple lines that if "0" is the answer, it rechecks the next line that is the same as the Vlookup(A2 part.
Can anyone help me?
Thanks,
Claire
Can you help me with my formula....
=IF(VLOOKUP(A2,Master!E$3:P$1805,12,FALSE)=L$1,"864","0")
That's the basic formula but I often have multiple lines that if "0" is the answer, it rechecks the next line that is the same as the Vlookup(A2 part.
Can anyone help me?
Thanks,
Claire