Vlookup giving 3n/a

IM USING VLOOKUP TO FIND a VALUE IN AN ADJACENT CELL, BUT IF THE VALUE ISNT LISTED THEN I WANT IT TO DO NOTHING..


EXAMPLE

=VLOOKUP(1100,Tuesday!A:F,6)

BUT IF THERE IS NO 1100 TO LOOKUP THEN GIVE ME A 0 VALUE OR DO NOTHING...

THANKS FOR ANY HELP

Try

=IF(ISNUMBER(MATCH(1100,Tuesday!A:A,0)),VLOOKUP(1100,Tuesday!A:F,6),"")

Note: You Vlookup may not be giving correct results if you are looking for exact matches in a non-ascending ordered list. If that is not the case add a FALSE parameter as the 4th argument in the Vlookup function

If you are satisfied with the solution provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save