Search results for query: *

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

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

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

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-

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

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

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

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

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

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

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

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

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! =)

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! =)

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?

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

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

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

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]

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?