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?