Lookups

diggerdidoodar · May 21st, 2002, 05:00 AM

Please help!!
Below is a list of imported data:-

P5-NOSPRAG-KIT|6500029|0|46.0
P5-NOSPRAG-KIT|6500029|1|46.0
P5-NOSPRAG-KIT|6500029|2|34.0
P5-NOSPRAG-KIT|6500029|3|34.0
I need the column 4 data (46,46,34,34) for each occurence of the column 1 part number, but vlookup only gives me first row???

sen_edp · May 21st, 2002, 05:06 AM

Hello

Why don't you use autofilter ?

diggerdidoodar · May 23rd, 2002, 01:04 AM

there are alotof users so I wanted to keep it as simple as possible

Chris Davison · May 25th, 2002, 06:10 AM

Autofilter is pretty simple.....

failing that, how about a pivot table ?

May 21st, 2002, 05:06 AM	#2
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	Hello Why don't you use autofilter ? __________________ Best Regards Andreas

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 21st, 2002, 05:00 AM	#1
diggerdidoodar New Member Join Date: May 2002 Posts: 42	Please help!! Below is a list of imported data:- P5-NOSPRAG-KIT\|6500029\|0\|46.0 P5-NOSPRAG-KIT\|6500029\|1\|46.0 P5-NOSPRAG-KIT\|6500029\|2\|34.0 P5-NOSPRAG-KIT\|6500029\|3\|34.0 I need the column 4 data (46,46,34,34) for each occurence of the column 1 part number, but vlookup only gives me first row???

May 23rd, 2002, 01:04 AM	#3
diggerdidoodar New Member Join Date: May 2002 Posts: 42	there are alotof users so I wanted to keep it as simple as possible

May 25th, 2002, 06:10 AM	#4
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Autofilter is pretty simple..... failing that, how about a pivot table ?