return

Good morning everyone, I hope someone can helps with this one, I have the following formula(copied down through rows etc) =IF(D2=G2,"ok",IF(D2>G2,"Supplier MPQ higher","Check pack multiple")) to return a simple text answer, but what I wish to modify this (if possible) to show that t if G2 is...

I have a table with multiple columns. I am wanting to search one of those columns to find if there is a value > 0. If so, I want it to return back to a main table dashboard that value in one column and in the second column, it will return the number in the column it was searching. It would...

Hi all, i have a question on time format when vlookup. how can i easier to identify (conditional formatting with color or vlookup to return with my request only?) the table below if i want greater than 18:30(subject to change in A1) <tbody> 18:45 21:30 17:15 16:30 21:00 19:45...

Hello So I have manged to find a formula to help produce a list of unique names based on rules, but i can only get it to return the first name from the whole list. {=IFERROR(INDEX(Master!$B$2:$B$500,MATCH(0,COUNTIF(H$2,IF(Master!A$2:A$500=H$2,Master!B$2:B$500,H$2)),0)),"")} "Master B" is the...

Can somone please look at this and tell me how i can get the selected data from the treeview after its selected to return a value back to Column E. The code i have in there pulls the data from the list in Column A-D and shows in the treeview. I want the user to be able to select what they want...

hello, i would like to know if i want excel to return certain values based on results received. example: if employee reaches 95% then he gets 1 if 98% then 2 100% then 3 120% then 4 200% then 5 what is the equation to use for such examples

The following INDEX/MATCH formula works but, I would like the return to be just the numbers (no text). Help modifying formula would be appreciated. =IFERROR(INDEX('SDC TRIRIGA'!$C$1:$C$15000,MATCH(A2,'SDC TRIRIGA'!$A$1:$A$15000,0)),"") Current Return: <tbody> REQ-1187706 </tbody> Would...

Hi, I am using this formula =CHOOSE(SUMPRODUCT(--(B11=A1:A8)), VLOOKUP(B11,A1:B8,2,0), VLOOKUP(B11,A1:B8,2,0) & ", " & INDEX(B1:B8,MATCH(B11,A1:A8,0)+1), VLOOKUP(B11,A1:B8,2,0) & ", " & INDEX(B1:B8,MATCH(B11,A1:A8,0)+1) & ", " & INDEX(B1:B8,MATCH(B11,A1:A8,0)+2)) to return more than one...

I apologize in advance as I will try my best to explain my predicament. I am attempting to find a way to calculate net gain or loss from the purchase or sale of an item. However, by inputting negative values in to the items sold column, it is throwing off my numbers. Initially I was using a...

Hi All Got myself really stuck with something I should know better. I have values in column D of my spreadsheet which will range from 2 to 11 I want to write a formula to return a value in column E along the following lines When Col D cell 3 <= 3.5 then 1 When Col D cell 3 >= 3.6 Or D3 <=...

Hello. In both columns A and B (A1:A600, B1:B600) I have numbers/indexes in ascending order. Column A range is from zero up to a 599. Column B could contain negative numbers. I need to return index from column A for the smallest positive number from column B. Result should be placed in...

Hello, Trying the following formula and I keep getting an error: =IF((AND(E4="FT",(U4<=DATE(2010,10,10)),IF(V4>=160,L7,IF(P4>=12,L6)))) I'm trying to meet the following condition: If the cell in E4 is FT AND the date in U4 is less than 10/10/2010, evaluate the following: if cell V4 is greater...

Hi guys, Long time admirer, first time questioner. I wonder if anybody knows of a macro which will return the range which has been selected. For example, if I highlight cells B1:E2, the macro will return the value "B1:E2"? Thanks in advance!

I am trying to figure out if there is a way I can return a value from an adjacent cell based on a selection. This is an example of what I am trying to do: I have a worksheet label "1" in which is need to calculate billing amounts for items which need to be selected from a list. Then I have...

<tbody> IN AM OUT AM IN PM OUT PM Return 1 1 1 1 TRUE 1 1 0 0 TRUE 0 0 1 1 TRUE 1 0 0 1 TRUE 1 0 0 0 FALSE 0 1 0 0 FALSE 0 0 1 0 FALSE 0 0 0 1 FALSE 1 0 1 1 FALSE 1 1 0 1 FALSE 1 1 1 0 FALSE </tbody> how to make the formula with that kind of combination then will...

I have code that enters text in a footer, how do I force vba to enter a carriage return in the footer so the text is on more than 1 line?

Hi, I have a spreadsheet that gets dates manually inputted into it. What I need is a formula to return a date 7 days on from the manual input but has to be a Monday, Thursday or Friday. I.E. Manual input is 1/10/19 or 2/10/19 I would want the returned date to be 10/10/19. Manual input 3/10/19...

I'm trying to create a formula that will return the corresponding date when the sum of cells containing "Q" equals a specified value, i.e. when the count of cells in column B =2, the date 4/22/18 would be given: 2/17/18 Q 4/22/18 Q 7/8/18 -- 10/20/18 Q Thanks for the assistance!

Hi guys, Wondering if anybody a help with the following: I am currently using the following formula to return blanks when an error results from 'E25' being blank: =IFERROR(VLOOKUP(E25,'WORKSHEET'!$A$1:$S$1000,19,FALSE,"") However, when E25 is not blank but row '19' in '$A$1:$S$1000' has no...

Hello, looking for some help. I have a raw data tab which contains a large data set which can be grouped into 5 categories based on the attribute in column 'BB'. I have 5 tabs which I would like to look up the value in column BB and if it is a match then pull into the tab. Preferably I would...