Formula To Find Value Then Pull From Another Cell?

Aug 13, 2014

The below is an example of some data I have in a workbook ...

Basically I need a formula to look through the data and search for any fails within Column A then I want it to pull the Reason

The Pass / Fail could appear anywhere within the range and we will only get a reason for any fails

1Result Reason
2Pass N/A
3Pass N/A
4Pass N/A
5Pass N/A
6Pass N/A
7Fail System Error
8Pass N/A
9Pass N/A
10Pass N/A
11Pass N/A

View 2 Replies


Find Unique Number In Cell And Pull Data Into New Cell

Dec 30, 2013

I have a column with unique identifiers (numeric) that are included in another column. I need to find this number in the column and pull the data from that column into a new one. For example:

Unique Identifier: 28530

Is included in this string: 10.1.8........28530_201_10-....

I need the content from the string pulled into a new column. It seems there would be a LOOKUP that would work, but I'm not able to figure it out.

View 3 Replies View Related

Find Repeating Words In One Individual Cell Then Pull The Numbers Right After It?

Mar 19, 2014

I have a set of data in once cell and its strung out. I'm trying to pull the numbers that follow certain words from that data. That's easy enough with the find and mid function for the first one. But after that I have a repeating word (see below) and different numbers that follow it. So I want to pull the second number string after that word, the third and so on.

I've attached an excel file that explains this better.

View 4 Replies View Related

Formula To Pull Out Numbers And Order Them From Cell?

Oct 3, 2013

In the above pic I need a formula that goes down column B, looks at column A, picks out all the different numbers from column A, orders them lowest to highest and separates them with a comma. The words in column A of course are ignored.

View 9 Replies View Related

Formula Required To Pull Some Info From Cell

Apr 15, 2008

i have a list of names which also contain e mails addresses after the names, they are displayed as (In column B onmy spreedsheet)

Armani Stevens/GB/companyname/GB@soso

what i need from the above is just the name (up tp the first backslash)

so i would need Armani Stevens and disregard the rest.

What i would then need to do is to take the name and then see if the names is in the list which is situated in column A,

so to sum

once i have Armani Stevens extracted from Coulmn B i would want to see if this name is in Column A

Names are obviously of all different lengths and there is always a space after the first name and surname

View 9 Replies View Related

Referencing To Find Pull Numbers

Oct 7, 2009

I want to input numbers into a master sheet by having it referenced to a name. For example; I will be inputting a report on monthly sales, which contains a company name, and then a value. However, this report doesn't always necessarily contain all the companies listed on the master. I want to simply put this report on a page, and have the referencing pull the numebrs to the approriate company on the master page.

In the attachment - I want the numbers from Sheet 2 to be entered into their appropriate match in the Master sheet (sheet 1) - without copy and pasting (becuase in reality, I have 200+ company names and numers I'm dealing with).

View 3 Replies View Related

Formula- To Pull Cell Values Similar To A SUMIF Function (SUMIF(range,criteria,sum_range))

Oct 25, 2007

I am trying to pull cell values similar to a SUMIF function (SUMIF(range,criteria,sum_range)). For example, in A1 I use a data list created from data elsewhere on the spreadsheet. In the data I created elsewhere, there are 2 columns being used. The 1st column is the information that is being used to create the list and the second column contains specific values (number or text). In the dropdown menu I select an available value (text or number) . When I have selected that value I would like cell A2 to show what the cell directly to the right of it shows from the data I have elsewhere in the spreadsheet as mentioned. I have tried the SUMIF function however it seems to exclude certain values (number or text) and I am not sure what else to use.

View 9 Replies View Related

Find Last Cell In Column And Paste Formula In Next Blank Cell Then Repeat On Remaining Columns

Jan 14, 2013

I need a macro to find the last cell in the column, then copy the formula to the next blank cell. Then, it goes back to the last cell (above) and paste's values. Then, go to the next column and repeat the process. I can do this but have to call each cell separatly...however, I would like to do it in a loop to simplify things. It would be great to even be able to just set the start and ending columns. Here is my current code:

Dim rng As Range, aCell As Range
Set rng = Range("C8, D8, E8, F8, G8, H8, J8, K8, L8, M8, N8, O8, P8, Q8, R8, S8, T8, U8")
For Each aCell In rng
Application.CutCopyMode = False

[Code] .......

It does not go to the next column, instead it stays in the same column and repeats the process.

View 8 Replies View Related

Pull A Value Using A Range Formula

Feb 7, 2010

I need to create a formula that will automatically give a ranking based on where the revenue lands in between. If its between the range then it gets an A-F ...

View 9 Replies View Related

Pull Until . Found: Pull The Number From The Right Until It Hits The Decimal Sign

Jan 7, 2010

I have a column of numbers each have a 0. infront of them (example 0.2346
0.5698). I want to pull the number from the right until it hits the decimal sign. So for the two above the result would be 2346 and 5698

View 2 Replies View Related

Formula To Pull Number From Another Spreadsheet

Mar 29, 2014

I have WorkbookA that pull numbers from WorkbookB. In Cell D2 of WorkbookA is the name of WorkbookB. The data to be pulled from WorkbookB is in Cells H364 through S364, H being data for January and S being data for December. In January, the data from Cell H364 is pulled into WorkbookA. In February, the data from Cell I364 is pulled into WorkbookA, and so on.

The formula can be written such that, based on WorkbookA indicating in Cell B14 the current month, each month pulls the correct month's data from these cells in WorkbookB.

View 14 Replies View Related

Formula To Pull First 6 Digits From One Column To Another

Apr 15, 2014

I have a list of project numbers in column "J" and i need to pull the first six digits of the project number to column "O"

View 4 Replies View Related

Formula To Pull The Final Value In A Column

Jun 15, 2009

If I have a columns of numbers that vary in length, and can have empty cells between the final value and the formula to pull the number (of varing lengths), what formula can I use to repeat the final value?

For example - here are two columns:

<formula to pull 46,594>



View 2 Replies View Related

Date Formula To Pull Table Value

May 27, 2009

i have a table with year and day in rows and months as columns. I'm looking for a formula that will look up a number in that table based on the date given in colP and put the number in Q. See example.

View 2 Replies View Related

VBA - Find Cell Containing Text And Use An Offset Cell Value In Formula

Feb 13, 2014

I'm trying to do a column of individual discount calculations using a discount percentage found in a cell two to the right of a cell containing the text "Total SP:" that is always upwards and to the left of the cell where the formula goes (but could be two rows or could be 20). There are multiple "Total SP:" cells in the sheet - I always want the first one upwards. I have created the following but I get #NAME? where I hope to see the discounted value.


Dim Discount1 As Double
Discount = Cells.Find(What:="Total SP:", After:=ActiveCell, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlPrevious, MatchCase:=True).Offset(0, 2)
Range("R9:R" & LastRow).Formula = "=IF(J9>0,$E9*(1-Discount1),0)"

I've just thought, the Cells.Find needs to be redone for each cell where the formula is inserted to ensure it always catches the correct discount and this isn't going to do that - it's going to find it once and always use that single value.

I think this needs a Loop or something and to move the ActiveCell down one after the formula to get it to redo the Cells.Find.

View 1 Replies View Related

Formula To Pull Data Based On One Cells Value

Apr 23, 2014

I am trying to have my spreadsheet pull data from one tab and cell if they match another.

Tab "Ag Orders" column H, I enter data in lets say cell H37. Whatever I enter, if it matches tab "reference List" C:C, then "ag orders" column G (specifically G37) should enter the data in "reference List" D:D

So since in H37 I entered 34000 - 314620, G37 should pull in Farm Operations since on the referene list tab that string of numbers (C11 matches up with D11)

a little confusing but I hope it makes sense.

13-14 budget-AG.xlsm

This isn't the exact formula I used but something like it and it wasn't working. It wouldn't match the data up correctly on a few of the department names

=IFERROR(LOOKUP(H35,("11000 - 311010","11000 - 311020","11000 - 311510","11000 - 311610","11000 - 312010","17800 - 311010","17800 - 311510","17800 - 312010","34000 - 314610","34000 - 314620","34000 - 314640","34000 - 314660","34000 - 314680","34000 - 314690","81008 - 840008","81009 - 840009","13863 - 312040","13864 - 312050","71060 - 521620"),

[Code] ..........

View 1 Replies View Related

Excel Formula To Pull Data With 1 Condition

Jun 14, 2014

Looking for formula to extract data from the raw data table list to a new table list when an option is selected from the dropdown list.

Sample data attached and desired outcome in green color.


Product 3

ProductTargetOff TargetTarget Range

View 3 Replies View Related

Lookup Formula To Pull Multiple Answers To A Row

Jul 2, 2014

Instead of trying to explain my challenge, the attached workbook should be self explanatory. My answer is surrounded by the box. I need a formula that would automatically provide this output.

Lookup Scenario.xlsx‎

View 9 Replies View Related

Formula To Pull Information From Database File

Apr 26, 2012

I need building a formula to pull information from a database file. The purpose is to try to interpret the data so that I can analyze a time period along with it's content. I don't know how best to explain it. Basically I have a table and I want it to pull information based on 3 criteria: time, type, and total. I would like for the formula to identify a time frame, then identify a type, and then take the totals and add them together.

Time / Type / Total
11:31 /1 / 4
11:43 / 1 / 6
12:04 / 2 / 1
12:31 / 1 / 3

Time / Type / Total
11:30 - 12:00 / 1 / 10
12:00 - 12:30 / 1 / 3

The top is the database and the bottom is basically what I want to happen on the other table. Pretend the / and dividers for each column.

View 9 Replies View Related

Formula To Look Down A List And Pull Out Unique Names Only?

Jun 4, 2014

I have a list of names in column A these names repeat themselves a lot and I don't know how many there are.

now I want to make a list of the names in column c starting at C2 that looks down row A finds names and puts them in column C one after the other.

View 3 Replies View Related

Using Indirect Formula To Pull In Data From Different Worksheet

Jul 7, 2014

I am trying to use the indirect formula to pull in data from a cell in a different worksheet using the tab name as my reference. For example:

I have my tab name in cell A2, then I am using this formula to pull the information from cell g29 on the tab listed in A2, but its not working:


Also, my tab name in cell a2 is a date, does that make any difference? I've tried a couple variations on the indirect formula and have gone from the #REF! error to the #NAME? error.

View 2 Replies View Related

Find Column That Has Value And Put Formula In Cell

Dec 11, 2008

I had posted this earlier but it was moved. I think this post will explain it better. I put data into a worksheet called "Budget" each week. When I put the data in I type a date in Cell "BL7". In another sheet called "EV Report" row 8 has week ending dates (i.e. Sunday of each week). I want to run a macro after I change the date ("BL7") and data in the "Budget" sheet that will search row 8 of the "EV Report" sheet to find the date in cell "BL7" of the "Budget" sheet. Once it finds which column that date is in I want it to put a formula in row 13 of the same column (the one found based on the date of BL7) that will add the value in row 12 of the same column with the value in row 13 of the previous column.

I don't want the formula to be there until the macro is run. I'm doing this because I have a graph of the formula and I don't want the graph to show the other cells.

View 2 Replies View Related

Find Cell With Partial Formula

Aug 27, 2012

I need to find the last row of a table I'm manipulating with VBA. The last row contains only the subtotal of a specific column. I am currently using the following code to find the last row. (NB:'j' is the the specific column, the formula in the last cell is shown in the Do While conditional, but the value 109 can change)

Do While Cells(i, j).Formula "=SUBTOTAL(109,[BID PRICE '#1])"
i = i + 1

However, this code will not work if the user adds a row to the table. I've tried using a partial string search, but the do while conditional is always true. I assume this is because the cell contents are a formula and not a string.

Can I change my conditional to search for just the "=SUBTOTAL" portion of the formula?

View 1 Replies View Related

Find Empty Cell And Add Formula

Apr 24, 2006

I have a spreadsheet that is pulled automatically from an access database.
The information that is pulled is invoices that have been paid for each of the temps working for our company.
Each month I have to give a figure per cost code on how much they are accruing so that they can see how much is still outstanding.

Right so what I am trying to do is have a macro take the temps charge rate then * 40 hours and place the amount into the empty cell.
As you will see in the attachement some of the cells are coloured. The purpose of the colouring is show that a invoice has been processed and paid for that week so no value is needed in that cell.

Then total all the cells at the end.

View 9 Replies View Related

Formula To Find Last Populated Cell In Row

May 30, 2007

i need to find the last populated cell in the row say I9:CN9 and return the description for that column the resides in I5:CN5 and then fill the formula down for about 500 rows, just not sure even where to begin, do i need a custom formula in VBA? as i can't seem to find a combination that works built-in...

View 5 Replies View Related

Find Last Cell Used And Create A Formula Using That Cell

Jul 31, 2014

I want to find the last used cell within a column. Then I want to write a formula to find the Min from the cells above (Row 1 is a Header, so I do not want to include it).

Like this:
Column A has data in an undetermined amount of rows below.
A1 is a header and I do not wish to include it in the formula.
A2:A15 has numerical data.

I want A16 to have the formula =MIN(A2:A15)

Next time there may only be data in A2:A10 or maybe A2:25...

View 2 Replies View Related

Formula / Function To Pull In Multiple Lookup Values

Aug 21, 2014

I am trying to replicate a payslip from a list of data on a worksheet.

The list of data contains the employee name, location they worked, and number of hours.

Each employee will work at multiple locations throughout the month, perhaps 10 or so.

The payslip must contain each location worked along with the relevant data, in a list so to speak.

What function can I use to pull this in? Of course if it were one location I would use vlookups to pull in data. As this only returns the top match I would then need a different formula to pull in the second location in the cell underneath?

View 6 Replies View Related

Excel 2003 :: Formula To Pull Data From One Sheet To Another?

Jan 16, 2014

I have Excel 2003

My spreadsheet has multiple lines of data for multiple items (have a specific item #) and I need to be able to enter an item # on a different sheet so that the requested information can be pulled from the data source. The items have information on multiple rows. I need to have all of the rows pulled into my output file when I specify the specific item. #.

I have attached a spreadsheet showing the type of data is contained and what my desired output would look like.

View 1 Replies View Related

Create A Formula To Pull The Person's Name And The Avg Number Of Cartons

Dec 5, 2007

I am trying to create a formula to pull the person's name and the avg number of cartons sorted for the month from this spreadsheet.

I've attached a sample of the spreadsheet I created, you will see at the bottom I would like to see the person that had the highest avg for the month and the person with the lowest avg for the month.

This is just a simple spreadsheet to track productivity of my sortation employees.

View 9 Replies View Related

Formula Tweaking To Pull Adjacent Column Data?

Nov 18, 2011

I have three columns of data laid out like this:

Column A Column B Column C Column D
(blank) Purchase Orders Shipments # Shipment Reference Field
12345 1ZX123 xxOO12346
12346 1ZC345 KJH12347--45
12347 1Z7YYT 0000012345XXX

I'm trying to write a formula for column A that essentially looks at the field in column B, finds the instance of the data anywhere in the entirety of Column D, and when it locates it puts the corresponding field from Column C of that line in the results of column A. So the result above would turn out like this:

Column A Column B Column C Column D
(blank) Purchase Orders Shipments # ShipmentReferenceField
1Z7YYT 12345 1ZX123 xxOO12346
1ZX123 12346 1ZC345 KJH12347--45
1ZC345 12347 1Z7YYT 0000012345XXX

I have the origins of a formula here...but I don't know how to put in the part where i'm retrieving the data from Column C of the same line as the target data.

=INDEX($D$1:$D$100, MATCH(B1,1*LEFT($D$1:$D$100,LEN(B1)),0))

View 2 Replies View Related

Copyrights 2005-15, All rights reserved