VLookup and List data validation

[lynanee]

I have a workbook with various worksheets and I created a list (data validation) and used vlookup all in one. But when I select an item on the drop down list, it doesn't open the corresponding item as it should.


=VLOOKUP(B7,'Weekly Program Journal'!A59:AF65,32) is the formula that I used

 

[Luke M]

Welcome to the forum!


I'm guessing you want the last argument so that formula will find exact match:

=VLOOKUP(B7,'Weekly Program Journal'!A59:AF65,32,FALSE)

 

[lynanee]

Hey Luke that's awesome. It worked! Thanks for helping me out.