I'm new to VBA and i'm trying to write a vlookup function to search different sheets when given information and what sheet to look on. the code i have so far is for a command button:
Dim Sheet as String
Dim Price as Double
Dim OD as Double
Price1 = WorksheetFunction.VLookup(OD...