vlookup multiple corresponding

[Guest]

How can use vlookup to return more than 1 corresponding return? Normally
vlookup returns 1 value. The thing is that there is a formula with SMALL
doesn't work since my returns are not numbers but text.
Can you help me?

Thanx in advance
Chester

 

[Niek Otten]

Hi Chester,

Look here:

http://office.microsoft.com/en-us/assistance/HA012260381033.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| How can use vlookup to return more than 1 corresponding return? Normally
| vlookup returns 1 value. The thing is that there is a formula with SMALL
| doesn't work since my returns are not numbers but text.
| Can you help me?
|
| Thanx in advance
| Chester