Hi Excel Forum,

I've always struggled with VLookups and I was hoping someone could disect & demystify the following formula for me...

=IF($Q29="",0,VLOOKUP($A29,Sheet3!$A:$CL,S$1,FALSE))
Thanks in advance...