look up a value from a range and return several corresponding valu
 

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

look up a value from a range and return several corresponding valu
 

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
|