Help: Need Search For Spreadsheet

[MisterLan3]

I've attached what I'm working on, I'm not savvy with Excel at all.

Here's what I'm trying to accomplish, it's pretty cut and dry.

The 'campaigns' sheet is my data selection

The 'Search' sheet is where I need help.

I want to be able to type a search term (business name, ID number, Status) and have the information from 'Campaigns' populate.


For Example: The first campaign is Vernon Blvd Pharmacy

I want to be able to type "Vernon"

And the search would populate those three columns with the business name, MBID and Status (Columns B, C, E) along with whatever other results have Vernon in it.



I don't know if I'm being very clear, any help would be appreciated. Again very new with excel.








It won't let me attach the workbook.

[stnkynts]

Is it not letting you attach the workbook due to a large file size?

[MisterLan3]

I don't imagine so, as it's only 51kb

\1


That is the error when trying to attach.





Basically I have the search sheet designed (seperate from data) I just need it to pull information from columns B C and E

[stnkynts]

I have no idea. Most people do not have an issue uploading workbooks. Your problem sounds fairly easy but we really need the layout and some data to work with for testing purposes.

Maybe save it as a new workbook with a different extension and try removing all non pertinent information.

[MisterLan3]

I could try to e-mail it to you? I may not be able to open it due to firewalls at work.

[alansidman]

Instructions to attach a workbook.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

I suspect that this can be solved with the vlookup function.

[MisterLan3]

Yes, I posted the error I get when I do it. I know HOW to attach it's just not currently working.

[Leith Ross]

Hello MisterLan3,

When I have had trouble uploading, that is the upload manager does not open a selected file for download, I click on the Basic Uploader option. Have you tried uploading the workbook that way?

[MisterLan3]

I appreciate the attempts at help, honestly I'm thankful for such speedy replies.

But I don't think I'll be posting anymore, as we're still stuck on the initial issue.

Yes I've tried basic upload
Yes I know how to attach a file
Yes I have tried saving it as a different type

In my second post I included an image of the error I receive when trying to upload the file.


Thanks anyways everyone.