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

G

Guest

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
 
N

Niek Otten

Hi Florence,

Look at this tutorial:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return value from range with "range" of values 2
Lookup within a range of values 1
Lookup a value within a range 5
search from range in column 1 and print from corresponding values 1
How to look up a value in a list and return multiple corresponding 2
Look up two values in different columns and return matching value 5
Look up range and return value 5
Looking up a named range and returning value into a cell 3

Top