Search Function for a workbook

so I'm trying to build a search function that I cannot seem to figure out. what I'm wanting it to do is search through the data on one sheet and provide an answer on the search function sheet. for example and cell A1 I want to type in 23-11-01 and in cell B1 I want it to return the gallon amount that corresponds to sell A1 on the first sheet.

For clarification the data I have will be in columns A,C,E,G etc. and the corresponding result I need returned will be directly next to the search term i.e B,D,F,H so the search term in cell A1 will need the result displayed from cell B1

TLDR I want to be able to have Excel search through an entire set of data and return just the one answer from the data I provide