Help with VLOOKUPs on non-sorted data

Hi there,

I basically want to perform a VLOOKUP, but with it associating the values to different columns. So I want the ID column in Sheet 2 to match up with any of the values between W1 and W5, then give me the result of the tank number in Sheet 1. I think the problem is the numbers in W1 to W5 aren't necessarily in order, and excel can't handle it. I would change them, but it can't be arranged in any other way because each W value associates to a cup with a weighted sample.

Anyway, I hope that made some sense, and I'd really appreciate the help ASAP.