On Jan 29, 7:33 pm, "Mike Fogleman"
wrote:
Good catch!! I didn't even notice trying to return the 5th column of a one
column range.

Mike F"Martin Fishlock" wrote in ...

Hi Chad:

Vlookup needs the key to be on the left of the data.

Thanks for the assistance, unfortunately I have not remembered the
golden rule of vlookup, always needs to be from the left. In this
worksheet all of the values that need to be searched through have to
be in the right most column. I was able to test both of your
suggestions and they work very well with the correct ranges. They will
always be useful for future projects.

Thanks again,

Chad