Vlookup formula Decoding help needed...

Hi Excel Forum,

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

Please Login or Register  to view this content.

Thanks in advance...

Originally Posted by FDibbins

Assuming this is working for you...

1st, it is testing to see if Q29 is empty, if so, it returns 0 (zero)
If not, then it triggers the vlookup()
syntax for vlookup is...
=VLOOKUP(what-you-want-to-find,range-to-search-in,column-that-contains-the-match,FALSE) FALSE is for finding an exact match
so your formula is looking for the contents of A29, in sheet3 in the range A:CL (not a great idea to use entire column ranges with vlookup), it is then moving across the the column number specified in cell S1, and bringing back an exact match

Righteous Explanation! Thank you I will mark this thread as solved.