vlookup or match finding multiple instances

Posted by steve w on September 15, 2001 9:58 AM

Can someone help
lets say I have a big list of numbers in column A
Lets say I want to find the number 111 and there are 5 instances of that number in that column. I then want to return the contents of the cell to the right of each one.

I want to output all this to another page and make the first instance in cell A1 then A2.....

Does anyone know how I can do this.

Thanks steve w

Posted by Jimmy on September 15, 2001 5:00 PM

Enter the following on your second sheet:-
=VLOOKUP(111,Sheet1!A1:B1,2,0)
and fill down to the same number of rows as your list of numbers.

Sort the column containing the formula.
Delete the #N/A's.
Copy>PasteSpecial>Values

Posted by Aladin Akyurek on September 16, 2001 10:34 AM

See: 30755.html. (NT)

Posted by steve w on September 16, 2001 12:09 PM

I didn't work the way I wanted it to

It would require me to do some cutting and pasting to get the data to the top

steve w

Posted by steve w on September 16, 2001 12:17 PM

thanks for the new code