MrExcel.com - Your One Stop for Excel Tips & Solutions

vlookup help finding multiple instences of same value

Posted by steve w on September 13, 2001 9:04 PM


Can anyone help with this. I want to use vlookup to find a value then return the cell to the right of it. Then I want to use Vlookup again to find the second then third. I want to make sure it doesn't keep finding the first value.
I believe this may require an array formula, not sure.

Thanks for any help you can provide

steve w

Posted by Richard S on September 13, 2001 10:54 PM

Steve,

Do you want the first, second and third vales in three different cells? If so, the last variable in the vlookup function is how many columns across from the lookup value to return. To get the first column to the right, it would 2, the second would be 3, and so on.

HTH

Richard Can anyone help with this. I want to use vlookup to find a value then return the cell to the right of it. Then I want to use Vlookup again to find the second then third. I want to make sure it doesn't keep finding the first value. I believe this may require an array formula, not sure.