Hi Florence,

Look at this tutorial:

http://www.contextures.com/xlFunctions02.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Florence" wrote in message ...
| 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
|