Drop down list and filtering data

Originally Posted by Haseeb A

Hello Josh,

or try VLOOKUP like this,

=IF(VLOOKUP(lookup_name,names_machinery_data,2,0)=tools_dropdown_cell,"Yes","No")

Ok, I understand the basics of the VLOOKUP function but am not sure exactly how that would work with the IF statement, if possible do you have an example?