alternative to vlookup for cell 3, 4, 5 etc

[mitchell36]

This is my formula that looks at the date then goes to the tab named events check dates and if date matches it posts the information back at the first page.

=VLOOKUP(B3,event,8,0)

The problem is if I have items in columns 2,3, 4, 5 etc vlookup ignores these columns. I need the formula to do as above but look along the row and post information.

Any suggestions?

 

[Excel Planet]

Try below after you modify highlighted text in red (headers)

=INDEX(Event,,MATCH(B3,$D$9:$I$9,0))