return a value

Hi, I requrie a formula in sheet 2 cell AW2 through to AW99 to search using the data shown in Sheet 2 Cell A2 (to A99 as it will repeat on each row) This will then search for the same data in Sheet 1 Cell C2 to C99, and return the first occurance of the value shown within Column N that matches...

Hello All, I need this formula to return a 5 digit number with a - and 2 digits it is matching column A on sheet 2 =IFERROR(MAX(OrderNumb)+1,1) In Column a It reads 24001-1 24001-2 And continues till the end I would like it to return 24001-3 I have tried...

Hi guys, Column C C1: AS2_Receiver_AdvancedShipmentNotification C2: AS2_Sender_AdvancedShipmentNotification I have something like the above in my spreadsheet. I need to use the formula to tell me whether it's Receiver or Sender, so I used =IF(C1="Receiver","Receiver","Sender") formula...

Hi, I have two columns with values and want to check both cells in a row (A2 and B2) and depending on the value found return the quantity from sheet 2 column 2 Both corresponding cells (A2 and B2) will not have data but there will be data in either of them. Row Column A Column B 2...

So I am Struggling with finding a way to have a formula that will search column C for certain words that will then categorise them into column D. For example with the text cell C2 contains "Zoom" Cell D2 = Software, Cell C3 contains Zipcar cell D3 = Travel, C4 Contains " Voxi", D4 =...

Hi! I have 2 columns. Column A - Amount ($) all in absolute values Column B - Status (either named as Accepted / Cancelled) In excel, we could input a formula =IF(B1="Cancelled",-A1,A1) Can this be done in Powerquery? If so, how would I do this? Thanks!

I have some rows that are coloured in yellow or red and other rows with no fill or a different colour. I only want the yellow and red rows to return a value. When a row has a red or yellow fill, I have a separate column that should return a value (for example: "Y"). If not yellow or red, it...

Hi Experts Please help I am an office 365 user and I need suggestions on what formula to use for this scenario. I have quite large data sets so I need the most efficient formulas that will not crash my workbook (+-30000 rows 69 columns). Scenario I need to be able to determine if a person...

Hi, I required a formula to Cell no. C4 in a full Sheet, values to be pulled there as referring the Task & ledger codes from Sheet1, When i drag the formula from C4 to C11 values to be reflect there from sheet1 to full Sheet as per Task & Ledger Codes. Thanks, ABC1Task...

Each day I get in a bank statement, and on there I need to search within the reference column for specific text in the form of invoice numbers. but to get around the fact the invoice numbers and letters are different, I want to make a table with these values in, but have wildcards in between...

I really have never used vba before but i am really eager to nail this one. What I want to happen is if I input "X" to cell E7, it will show the word same in a range of cells (ex: H1:H50) and if I delete the "X" on E7, the text will also be removed. Please please help :help::help::help:

Hi, I need help to display data from one sheet if blank (or other value if that helps) and data from another sheet if the cell has been filled. I hope it make sense : ) Thank you. Kind regards Krillephar

I have run into a problem. So I have 2 colunms as follows: A B C D 1 123 2 444 9 3 666 4 888 7 5 123 6 666 3 7 123 1 8 444 9 444 10 666 So I want to look in Column A for the...

Working within a pivot table and have added additional columns this way people can see what they spent and projected in the past and input for the future. However I have slicers so you select your Branch which auto populates in Column L, based on the auto populated Column L (Branch) want J...

Hey Guys, Would really appreciate your help on this. I have percentages sorted from low to high in rows. They might be repeated many times. My first row contains time slots. I want to return the first matched percentage and corresponding time slot for % greater than 67% and less than 99% Eg...

I conducted a survey and I am trying to return a value using index match. I am realizing that some of the text of the survey has been edited, so my index match isn't finding what it needs to. I thought I would have a better return rate if I instead of matching the whole cell, I would match just...

Hi, I am trying to return a contract number from a table of data by looking at the Week number. I am only looking to retrieve contracts with a quantity in the desired Week. I.e. by look at week 11 I would like to receive Orange and Pear. The table looks like: <tbody> Q1 2017 Q2 2017 Q3 2017...

<tbody> Date Month Total <tbody> 19/07/2015 </tbody> <tbody> July </tbody> <tbody> 392 </tbody> <tbody> 26/07/2015 </tbody> <tbody> July </tbody> <tbody> 409 </tbody> <tbody> 02/08/2015 </tbody> <tbody> August </tbody> <tbody> 416 </tbody> <tbody> 09/08/2015...

Hi Everyone I have a data table that shows a list of times Trailers were tipped, from which site in time order such as <tbody> Date Despatch Site Time of Trailer Unloaded 28/02/2016 MD01 06:13 28/02/2016 KA09 06:56 28/02/2016 MD19 07:42 </tbody> I then on a separate sheet have a...

Hello, I would appreciate any help with following. I have two excel workbooks, both containing multiple worksheets. I need to do following: - search the excel workbook 1 for a text from workbook 2 - when it is found - return a value from a specific cell in the sheet in workbook 1 (sheet...