I have the following information:
A B C D
1 Part
2 12345
3 12345 nut galv 3/4"

I created a vlookup in cell A2 and wish to display multiple rows of data
from A3 thru A200, and over 4 columns. Everytime the part number changes I'd
like the rows to change. Any help would be appreciated. Thanks, Greg

Hi Greg

If you have multiple lines of data with the same part number, Vlookup isn't
going to allow you to display all of the rows. It will only display
information from the row where it finds the first occurrence of the part in
column A.

Instead, take a look at Autofilter.
Create headings in row 1 of your sheet.
DataFilterAutofilter and use the dropdown on Part to select the number
required, and all rows with that data will be visible.

Regards

Roger Govier


Greg wrote:
I have the following information:
A B C D
1 Part
2 12345
3 12345 nut galv 3/4"

I created a vlookup in cell A2 and wish to display multiple rows of data
from A3 thru A200, and over 4 columns. Everytime the part number changes I'd
like the rows to change. Any help would be appreciated. Thanks, Greg

Roger,
I agree with you, however I was hoping to have some vb code support to
provide automation. I rather save my key strokes. But thanks anyways. Greg

"Roger Govier" wrote:

Hi Greg

If you have multiple lines of data with the same part number, Vlookup isn't
going to allow you to display all of the rows. It will only display
information from the row where it finds the first occurrence of the part in
column A.

Instead, take a look at Autofilter.
Create headings in row 1 of your sheet.
DataFilterAutofilter and use the dropdown on Part to select the number
required, and all rows with that data will be visible.

Regards

Roger Govier


Greg wrote:
I have the following information:
A B C D
1 Part
2 12345
3 12345 nut galv 3/4"

I created a vlookup in cell A2 and wish to display multiple rows of data
from A3 thru A200, and over 4 columns. Everytime the part number changes I'd
like the rows to change. Any help would be appreciated. Thanks, Greg