The syntax for VLOOKUP (exact match) is =VLOOKUP(what-to-look-for-1st column-of-the-lookup-range,lookup-range,column-number-in-the-range, false)
Now if you want to retrieve a series of adjacent cells this is possible with an array formula.
Eventually post a sample sheet?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post