How do I luse VLookup and / or Match to look up a value from a range, such as
Pay-rate, then return several values corresponding to that row?

Example:

Pay Range SSN Amount Health Ins.
(column A) (Column B) (Column C)

9,000 - 9999 500 600
10,000 -- 10,999 587 660
11,000 -- 11,999 612 700



thank you

Florence