Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Wizardbk

    HELP - Problems with Excel formulas

    I figured out the formula =IF(MATCH(A2,A:A,Items!$A:$A),A2,"") but now i need to join that with IF(ISNUMBER(MATCH(CONCATENATE($A2,B$1),Items!$C:$C,0)),"X",""). I tried using an AND statement but I keep on getting an error.
  2. Wizardbk

    HELP - Problems with Excel formulas

    Thank you this does make the X populate wherever the name is. Is there a way that the name can also be automatically added for example, I added a new name to the apple list, I would like it to be automatically added to the MASTER list.
  3. Wizardbk

    HELP - Problems with Excel formulas

    Apples Oranges Peaches Doe, John X Doe, Jane X This is basically the way my MASTER list looks, but with much more users. I have another workbook with a list of all users with apples. What i want to happen is when i enter a name on the list of apples...
  4. Wizardbk

    HELP - Problems with Excel formulas

    Im asking is there a way that I can add a name to the APPLE workbook and that name would be automatically added to the Master workbook
  5. Wizardbk

    HELP - Problems with Excel formulas

    I have a couple of workbooks that i need to link. I have a master list with a bunch of names and on that master list there is a check mark next to an item that the person has. Lets say for example John Doe has an apple, under apples there is a check mark. Now i have another couple of workbooks...

Part and Inventory Search

Back
Top