hlookup? if-then?

  1. D

    Link two cells of a column in different sheets if a value in a cell of other column matches in other sheet.

    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...
  2. J

    H-Lookup and Dates

    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...
  3. J

    Need help with Excel formula to find a group of data and return a value in that data set.

    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...
  4. S

    tracking visitors for church

    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...
  5. K

    Reference to number on another worksheet

    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...

Some videos you may like

This Week's Hot Topics