I'm beating my head against the wall here.

I have a sheet. In column B is a description like 'CPU TYPE' column C has
the Value 'Intel P4 3.0'.

There are thousands of values in this sheet. I was hoping to add a second
sheet and have a search function that says if any cell in B is = 'CPU TYPE'
then display the value in C on my new sheet. This will make me a summary
page. I can copy this sheet into other .xls forms and as long as the sheets
are the same name, it will work out well.

I started with =IF(Sheet1!D1:D5000="Computer Name","TRUE","FALSE") but that
looks at the whole column and doesn't return the correct value. I'm try
VLOOKUPs and the such but the nesting is getting difficult.

HELP?

I think I'd drop the formulas and use data|autofilter.

Select the range (all of column B???)
data|autofilter
then use the dropdown arrow to show the cells with "cpu type" (or use
custom|contains CPU Type)

If I needed just this list on a new worksheet, I'd copy the visible rows to that
new sheet.

But I'd try to keep the data in one spot and just apply the filter to show what
I want.

karatehero wrote:

I'm beating my head against the wall here.

I have a sheet. In column B is a description like 'CPU TYPE' column C has
the Value 'Intel P4 3.0'.

There are thousands of values in this sheet. I was hoping to add a second
sheet and have a search function that says if any cell in B is = 'CPU TYPE'
then display the value in C on my new sheet. This will make me a summary
page. I can copy this sheet into other .xls forms and as long as the sheets
are the same name, it will work out well.

I started with =IF(Sheet1!D1:D5000="Computer Name","TRUE","FALSE") but that
looks at the whole column and doesn't return the correct value. I'm try
VLOOKUPs and the such but the nesting is getting difficult.

HELP?

--

Dave Peterson

I was hoping to do it automatically.

I found that =VLookup("CPU TYPE", $b$1:$c$10000,2,false) returned the second
value in the column there, so this works pretty good.

Thanks for the help!

"Dave Peterson" wrote:

I think I'd drop the formulas and use data|autofilter.

Select the range (all of column B???)
data|autofilter
then use the dropdown arrow to show the cells with "cpu type" (or use
custom|contains CPU Type)

If I needed just this list on a new worksheet, I'd copy the visible rows to that
new sheet.

But I'd try to keep the data in one spot and just apply the filter to show what
I want.

karatehero wrote:

I'm beating my head against the wall here.

I have a sheet. In column B is a description like 'CPU TYPE' column C has
the Value 'Intel P4 3.0'.

There are thousands of values in this sheet. I was hoping to add a second
sheet and have a search function that says if any cell in B is = 'CPU TYPE'
then display the value in C on my new sheet. This will make me a summary
page. I can copy this sheet into other .xls forms and as long as the sheets
are the same name, it will work out well.

I started with =IF(Sheet1!D1:D5000="Computer Name","TRUE","FALSE") but that
looks at the whole column and doesn't return the correct value. I'm try
VLOOKUPs and the such but the nesting is getting difficult.

HELP?

--

Dave Peterson