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!

  • Congratulations gkittelson 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. katie2012

    IF statement with a nested vlookup

    I do have data in the other columns, I have names, addresses and other numbers in the columns- no formulas
  2. katie2012

    IF statement with a nested vlookup

    No, they already have an "N/A" in them else I would use ISBLANK. I just need a way to return column B data when it has a value in it.
  3. katie2012

    IF statement with a nested vlookup

    Hi, Can anyone please help me with my formula? I have 2 columns with different number sets in them. I am trying to look up the data from column A; unless there is data in column B, then I would like to see the data from column B. Here is an example of how my columns are set up- Column A Column...
  4. katie2012

    Suggestions please :)

    Hi! I need some suggestions on how to do something. I have a spreadsheet with several different categories of names and need a way to show duplicate names in each catergory. does anyone know of a clean way to show this information?
  5. katie2012

    Excel help- conditional formatting or other suggestions

    Its work related so I'm not able to release specifics but here is how the tables are set up: Category A # Location Name1 Name2 Name3 Name4 Name5 Name6 Name7 Name8 Name9 Name10 Name11 Name12 Name13 Name14 Name15 Name16 Name17 Name18 Name19 Name20
  6. katie2012

    Excel help- conditional formatting or other suggestions

    The data in the categories are just names I manually entered into a table.
  7. katie2012

    Excel help- conditional formatting or other suggestions

    Hello, I am working on a project in Excel where I have 10 different tables of categories. would like a way to see what data is also in the other categories and also which specific category. I was hoping I could conditionally format each line of data with a different color by category, but all...

Part and Inventory Search

Back
Top