hlookup? if-then?

Hi, I have the results of a survey with 4,500 responses, the report groups respondents with similar characteristics in different columns as shown below. I'm looking for a way to retrieve all responses for each question in one column. I've tried Hlookup with CountA, but it's just not working...

I have a workbook with 7 sheets containing part number of a product in column and its cost in adjacent column. And the 7th sheet contains total number of parts in all the sheets. I want to change cost of some products but then I have to do the same in all sheets. Is there a way by which it...

Any help is appreciated! I am using the following H-Lookup Formula to search for values that match with a certain date in sheet1 and move it to sheet2. Where I then shift it either left or right by C2 = one of the following #'s (-3,-2,-1,0,1,2,3,4) depending on the day I want my value to show...

I have a fairly large spreadsheet with about 5,000 lines and 100+ columns. I've taken a small piece of it and posted below to give you the layout of the spreadsheet. Row 2 is a number assigned to each month over the next 10 years. What I'm trying to do is write a formula that will look...

Ok, I need a formula/method to help with tracking our visitors to church. Here is the low down. I need to be able to type in the visitors and their info each week on a master list, then have a page listing all those who are on their first visit (first record/row) then move their info to a page...

HELP! I have a workbook with 4 sheets. Sheet2 is a table of copier counts from various copy machines, with machines listed down column A and month/year as column headings. Copier counts are manually entered. Sheet3 is similar but calculates the number of copies made the previous month on...