lookup date in column, search columns to right for name, return "x"

I have two worksheets. Sheet1 has dates in Col A and names in several columns (up to 8) to the right. Sheet 2 has all possible names in Col A, then dates (1-31) in columns to right. What I need is to put an "X" in the proper column for which day they pull shift. VLOOKUP works for column specific, ie. =vlookup(B2,sheet1!A1:A31,2,false) for whatever name it finds in Col 2, but I want it to look up the date in Col A Sheet 2, look for Bob in columns to right and return an "X" in cell for that day in Sheet2.


Thanks