look for a value

Hi - I wanted to see what the best method is to find a value in a pipe-delimited string in one cell that matches a value from a list and extract that value. Example: Metric Pipe Delimited Values 3 112356|229531|229327|229533|229532 5...

Hi all, i have a quick one, looking at the attached screenshot in h16 i have MAX looking at e10-f10 returning the highest number. i want to get the percentage from that column for the line i'm on if that makes sense :) Happy friday everyone! Dan

Hi, I have a set of data I want to compare to a table of set criteria but cant fathom out how to get a cell to bring back the right answer. Basically, we have criteria for "track categories" on types of rail and sleepers allowed, I then need to see if the types recorded meet the criteria set...

Hi I'm trying to look up data from a table of data (multiple rows and columns) and when that data is found I want to return the data in column A on the line that data is found to column B (in green) on another sheet. I have highlighted the column in green, in yellow is the example. 'South Hams'...

Hi, I required a help in formula where as a item code AI2 (Cell no 4 & 5)does not have any allowable rate , but in that item code has incurred value for Operatives and Equipment (Highlighted Cells). In this case i required a formula for AI2 should return as a Allowable value = Incurred value...

I have searched and can't find what I am looking for, so I had to post this question. I have a spreadsheet (not mine, it is a shared one created by someone else), it has columns/rows A1 - AW850. Not every column is populated, but the further most ones are. So, I need to return the value of the...

Hi, I am stuck with an excel issue, where I need to look values based on

Hi Team, I am looking for some help in getting the prior day data by compare with today's data table...refer the below two data set and help in formula to achieve the same..thank you <colgroup><col span="4"><col><col></colgroup><tbody> Day 1 Data Day 2 Data Project Probability...

Hello I'm trying to create a vlook up macro so I won't look up for each diifferent tabs as you may see below. 1. Master Worksheet 2. Reference Worksheet 3 Tab sheets namely - Sheet 1, Sheet 2 & Sheet 3 Master Worksheet - Master Tab <tbody> ID Name Age Subject Score 001 002...

Hi Team, I have this data with 100K lines and badly need to get a macro as I do this over and over again. This is the scenario: "Master" tab - Main Data Sheet "Reference" tab - Country reference sheet 1.) In the "Master" tab, what I need to do is add a blank column where the macro looks up...

Hello, I have this code which should read all rows that begin with the word ACCOUNT#: which is followed by numbers like this: 1-026-31-00000-3342. The whole this looks like this ACCOUNT#: 1-026-31-00000-3342. If the code reads some row and there is another row identical to the row read in the...

Hi all, I apologise if this has been answered before, but as anewbie all the terms are a little confusing. My challenge is this - I am posting all my accounting posts (lineposts?) in an Excel sheet. As part of the linepost, I enter in column C the account number that the amount of the post...

Hello! First time Posting, I've been given a new project at work where I need to look up customers and come back with the customers multiple contract numbers in one cell. As well as Summing their total order quantities in these contracts (of the same product) in a separate cell - While...

First, I want to thank everyone that contributes to these forums. I work extensively with Excel and often have to find creative solutions for culling large data sets, and up until now, I've always found answers to my questions without writing a post of my own. That said...I'm stuck. I have a...

I'm working on a better way to do attendance at our company, I'll try to explain this as best as I can, I'm hoping someone can give me some direction! I have a master list of all of our current employees. (Fig.A) At the end of the week I run a report that lists every shift that was worked...

I need help with putting my profit numbers in to the following range by using look Up Formula. My Range that I would like to see are: < 500 501-1000 1001-2500 2501-3500 above 3500 here is the real data that I like to put them in range by using Look up formula Profit: 1000 50 -500 600 6000...

Hi all, Firstly, I know nothing about excel formulas, I’m trying to return numeric values by selecting “cash” or “card” in a drop down box with this text that would return a value from multiple rows or cells with the return value, This is a cash book spreadsheet with July to June tabs, any...

How do i return the correct value in excel via a lookup Problem Tab Stock Col A = Item Number e.g 1001 Col J Return Value from Look UK Tab Shipping Col A = Item Number e.g 1001 Col G = UK Shipping Cost for item 1001 So i want Tab Stock Item...

Hi, I'm very new to writing Excel Macro's and I feel like it has to be possible, but I cannot find anything on how to do it. I am looking to have a macro; Open a certain sheet, search through a range of cells and if a certain value "R" is found take a string of text from a different column...

Im stuck! What I am trying to do: If cells from spreadsheet1: C1 and E1, match cells on spreadsheet2:C1 and D1 it will show spreadsheet2s data from cell E1. Thank you in advanced for your help.