## Formula changing when sorted

Hi all, I have a very complicated formula, that works!, but when I sort the data the formulas look up the wrong value and it stops working. How do I …

Hi all, I have a very complicated formula, that works!, but when I sort the data the formulas look up the wrong value and it stops working. How do I …

I have two customer lists, both from different systems. 1st list is a reference list of existing active accounts, while 2nd list is from an acquisition. …

I am looking for a formula to go into G2 that finds the combined sum in column D that is adjacent to the product in column C, but for the choice of product to …

I am hoping someone can help me solve this specific problem. I understand it may have something to do with VLOOKUP, or MATCH and INDEX and array formulas but I …

I have a table with these columns: Company, Person, Last Contacted. Now I want a table with all COMPANIES where no Person was contacted in the last 3 …

I need to find the marks from the two different tables, TABLE 1 TABLE 2 NAME PHY CHEM MATHS NAME HINDI SST EVS RAJNEESH 38 66 …

I have two sheets in excel, firstly I am wanting to find out which names are not in sheet 1 but are included in sheet two. Sheet 1 will eventually be …

Hi, I’m trying to search through multiple items (of which there are duplicates) to see if they have ever returned a TRUE result. The problem I’m …

Hi, I’m trying to search through multiple items (of which there are duplicates) to see if they have ever returned a TRUE result. The problem I’m …

I want to look up prices for styles based on which store they are in (field or house). The prices are different for both. For example, I want style 2012 price …

Hi I have been trying to use this command to organize data into a rating scale. The command is not consistant with the rating and for example will …

hello there, I have several names in a culomb (sorry for bad english), and pics in the culombs next to it. for ex. in A:2 I have X and in B:2 X’s …

=VLOOKUP(1,’Main Tracker’!A:F,6,FALSE) When I copy this formula down, I want the lookup_value, the “1”, to fill series so when I …

Please help. I’m seeking to VLOOKUP the values, as such. <!–table {mso-displayed-decimal-separator:”.”; …

I am trying to look at my employee time sheets broken down by date, time, and who was on at the time. My time sheet software give me their clock in and clock …

Hi! I have a report that I need to show the date the bill was paid on the same line. (QB wont spit out the report like this of course!) Currently, the …

through v lookup we can call some fields against a number, if that number come two time or more then two times only values shows against one number….rest …

I am using Windows 7 with Excel 2010. I need a to populate a cell in one worksheet with values from another worksheet using the following criteria. This is for …

Hello. I want to achieve the following. User selects the item they want in A1 (dropdown menu), called ITEM1 In the second sheet, there are tables with …

Hi I am looking for a solution to a problem in excel when trying to build a ss for a logistics company as followsIf column A has start point for a truckColumn …

=IF(SUM($K2+$N2+H2)-$M2<0,VLOOKUP($B2,’Container QTY’!$A$2:$B$219,2,FALSE),”0″) Hello – i am not sure how to …

Hi, Firstly sorry if my Excel lingo is a bit off as I’m self taught in Excel. Okay so my problem is simple, say if I had the letters a,b,c,d,e in the …

i think it should be done with match vlookup and offset but its too complicated. i need to show differences between revenues of client between 2016 month five …

The first table is the input table. The second table is the for the results. The result should display as follow: – If the end date of the …

Hi, thank you very much for your help. I have in about 30 worksheets in 1 workbook. In each worksheet-cell B3, I have expiration dates for materials. I …

Dear Excelgeek, I need your help to make formula for my study, here is the result table: Male Result Age Very Good Good Fair Poor Very Poor 10 …

Hi all, I’m looking for a solution to my excel problem. I’m not sure whether this can be done by using formulas solely, I hope it can be …

Jag letar efter ett sätt att hitta ett unikt värde i en matris och sedan returnera värdet i raden under det. Column 1 Clumn 2 Column 3 Bird …

I’m doing a VLOOKUP to find a value. On the following column, I need to find the value immediately below the one that VLOOKUP got. How would I go about …

Hello, I have two Excel sheets, each one contains ID and Quantity. I want to automate the task of comparing the two quantities together for the same ID. …

<!–td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}–> up front/ annually quarterly/monthly $1,000 $4,999 5% …

Please see data example below. In the input sheet, I need a formula that would give me the result for ABC’s Session 1, for January 2017. Then for …

Hello – I am wondering if it is possible to create an IF/VLOOKUP (or something similar) statement that does the following: There could be 2 rows …

I’m wanting to add up a row of values that are pulled from a vlookup in another spreadsheet. Some of these values will result in a blank because …

Hello, I’m trying to configure a solar pump system sizing sheet. Basically, after calculating several criteria, a solar pump model should be …

I’m using vlookup to populate a tally spreadsheet. It is working very well when the lookup value is a regular number – like 21073 (classified …

I use a software that is online to track my companies fleet. I am creating reports in excel for things like fuel consumption. I download the spreadsheet …

Hi, I am tryign to combine a VLOOKUP function and an IF statement. Basically I want to quality check pricing for a product using an ID number, so do a …

Hi … using Excel 2010 I’m looking to get a sum of 5 different numbers referenced by “codes”, and wondering if there is an easy way to …