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

    Excel 365- Formula Help - When A1=X and B1=Y, Return C1

    I have a spreadsheet with numerous rows of data. Each row is unique to a transaction. I want to get the result of C1 when cells A & B match certain criteria An example would be A=0 and B=(cust#). Each customer has various data. So I’m looking for a specific combination match, and then want...
  2. zinderellie

    Excel 365- Formula Help - When A1=X and B1=Y, Return C1

    I need help with an Excel formula. I’ll probably have a SMH moment when I get an answer… but drawing a blank right now. I want the value in C1 returned when the value in A1=x and the value in B1=y. Thanks! "If you can imagine it, you can achieve it. If you can dream it, you can become it."...
  3. zinderellie

    Vlookup Using Less Than (<) Symbol in Table Data

    Hmmm... I tried this and got the same result... N/A. My data is sorted in Ascending order. Name Sales Comm Rate Sales Range Comm % A 10,000 15.00% <1000 0% B 3,500 10.00% 1,000 10% C 900 #N/A 5,000 15% Columns are a,b,c, skip d, e, f. My formula...
  4. zinderellie

    Vlookup Using Less Than (&lt;) Symbol in Table Data

    Will Vlookup understand or recognize the use of the less than sign in the table data? For example <$1,000. I'm getting N/A as my result. Example in file attached. Thanks. "If you can imagine it, you can achieve it. If you can dream it, you can become it." -William Arthur Ward-
  5. zinderellie

    How to Find All External Links Within an Excel File

    I am hoping to find an easy way to locate all external links with an Excel file that has multiple worksheets. To clarify... I have an Excel file with multiple worksheets, and I need to make sure there are no external links in formulas that will produce a calculation error when this one file is...
  6. zinderellie

    How to Pull Related Data from One Excel Worksheet to Another

    Hi smallia, The formula I found does use the FALSE parameter, so my results are what I expected. This is the formula I used - VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) Where you see "range_lookup", I replaced with "FALSE". Thanks for adding to this post. I'm certain it...
  7. zinderellie

    How to Pull Related Data from One Excel Worksheet to Another

    Thanks a bunch Skip!! VLOOKUP worked like a charm. Have a fabulous day! =)
  8. zinderellie

    How to Pull Related Data from One Excel Worksheet to Another

    Hi There, I have been given a task to pull related data from one worksheet to populate another worksheet, and I am using the same column headings. First I had to identify parts in a current file that were not in an older file to create a new exception list. Now I need to grab some of the...
  9. zinderellie

    HP ZV5000 Intermittent Shutdown Problem

    After opening up our laptop, we noticed that only 1 of the 2 fans we can see stays running while the computer is on. The one that does not stay on is located closest to the outside edge. We took our laptop into a local repair shop to get an estimate, and he told us that since the fan kicks on...
  10. zinderellie

    HP ZV5000 Intermittent Shutdown Problem

    Hi There, We have a 4 year old HP ZV5000 laptop that is having intermittent shutdown problems. It appears to boot up fine and will stay on for varied periods of time, then just shutdown. It happens during both AC power and battery power. We have tried both during process of elimination...
  11. zinderellie

    SHTML Navigation Menu Page Position

    I have my site navigation menu placed vertically along the left margin. When I had it in a frame, it was position at the upper left as desired. However, I noticed the menu wasn't visible in IE. I am using Mozilla, but testing the view in both. I changed the menu code to: <table align="left"...
  12. zinderellie

    SSI menu.inc File Offline Viewing Problem

    I am trying to set up a site navigation menu using the following code on all of my pages. The web pages using this code are .shtml files. <!--#include virtual="menu2.inc"--> I am not able to see the results while viewing my files offline, but I can see them when uploaded to my web host. Is...
  13. zinderellie

    MAS500 Questions Allowed ?

    I have a question about how to process a refund against an existing credit memo in MAS500. If this is not the appropriate forum, can someone refer me? TIA! =)
  14. zinderellie

    Creating an Exception List in Excel

    You may be correct about moving to VBA. This formula didn't create a correct exception list. Back to the drawing board. Thanks for all your help Mike and Skip! =)
  15. zinderellie

    Creating an Exception List in Excel

    LNBruno - For your formula, should the -1 be -2? In your results, Part# CM776XCR should not be there since its paired # is present. Skip - I only get a True / False returned. Is that what your formula is designed to return?
  16. zinderellie

    Creating an Exception List in Excel

    Correct, but if the part directly above or below has no match preceding the "X" or "XCR", then I want to know, so I can research. The list is sorted alphabetically, and they should be next to each other. Let's say part # 8D40567 is above CM776XCR. Is there a way to test and create an...
  17. zinderellie

    Creating an Exception List in Excel

    The length varies, but they always end in "X" and "XCR".
  18. zinderellie

    Creating an Exception List in Excel

    I am working with an inventory list that has 2 parts that are supposed to be paired when the column is sorted. I need to create an exception list when one of these paired part #'s is missing. My goal is to quickly create an exception worksheet. Here's an example - CM776X CM776XCR If one or...
  19. zinderellie

    xlhelp is going on a long hiatus from Tek-Tips

    I really use this forum a lot to get solutions, and I have always received them so quickly. xlhelp... your contributions to this forum will be greatly missed! All the best to you in your new job! [2thumbsup]
  20. zinderellie

    Need Help with SHTML Menus and Footers Options

    Yes. I am just beginning, and have just created the left-side menu, top horizontal navigation, and footer information. Apparently, I now need to learn how to format these SSI sections. Do you know of some good reference sites to learn from as far as the formatting goes?

Part and Inventory Search

Back
Top