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

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top