About Us

G.[_2_]

Hi I actually have another similar problem, can you help me?

Hi I actually have a similar problem. Could you help me: Basically. I want
to look up number 222222 in column A, and have it returns 3 values from
column B which are 666666, 777777, and 9999999 in 3 separate column. Please
help!

1....................A....................B
2..............123456...............1111111
3..............222222...............6666666
4..............222222...............7777777
5..............222222...............9999999
6..............444444...............8888888

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Match and Lookup	Biocellguy	Excel Worksheet Functions	1	July 6th 07 01:48 AM
using MATCH, and LOOKUP	harvey1649	Excel Worksheet Functions	9	May 7th 07 07:05 AM
match, lookup ???	skimpw	Excel Worksheet Functions	0	August 14th 06 03:16 PM
Lookup? Match? pulling rows from one spreadsheet to match a text f	cjax	Excel Worksheet Functions	3	July 21st 06 02:51 PM
Lookup or Match	Robbyn	Excel Worksheet Functions	2	February 8th 05 10:29 PM

Menu

About Us