look up data

Please tell me to go away if you like. I have a table full of names (starting at B3 to H3), column A has which sites to work at. I need to 'transfer' the data in columns D to H from this table to another sheet depending on the site in column A I think this is a VLookup or a filter formula...

Hi Guys, I have difficulty of returning the values according to the conditions. Appreciate it if you could look into it and share your knowledges and expertise on this issue. some data in column A ( FY 22 and FY23 client code) has associated billing number(s) in Column D (Billing Numbers)...

Hi, I am looking for a way to use a lookup values to match the Chemical concentration with its respective Sample#: For Chemical 1 to 9 I don't have a problem, I can easily use 2D lookup Match& Index. However, for Chemical 10 and Chemical 11 this won't work as there are several rows. I could...

I am pretty advanced with excel and formulas; but am new to macros and that is what I believe needs to be created to achieve the desired results. I have attached my spreadsheet as reference but I am trying to accomplish several things If a name on the "placed" sheet has a 1 in column G on the...

Hi Guys, I currently have a main data table as below <tbody> WEEK TIMESTAMP DOCKET DATE SOURCE LITRES WEEKEND UNITS REGO DRIVER EMAIL SEALS TANKS AMOUNT 1 151526267 DD-2179 01/02/2018 Mittagong 40000 YES 245 CBD-098 Daniel blabla 262727 12 $400 1 26262727 DD-2180 01/02/2018 Gosford 40000...

<colgroup><col><col></colgroup><tbody> TENANT & UNIT # Total SF Buckhorn Material Handling 21,148 Unit: # 55 W - A Lease Start 11/1/1986 Lease End 3/31/2019 </tbody> Hi everyone, Does anyone know a way to lookup in the same column? I need to return the Name, unit...

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 Guys, I have a massive data set that needs vlook up and pivot. I have this excel file named "MasterData" with two tabs sheets namely: Master & Reference. The master contains a list of data while reference sheet has list of countries and its equivalent country group. Example Reference...

Hi Guys, I'm having a hard time with this. I need a code that will look for a value on multiple sheets and return it's sheet name. So in a workbook I have 4 sheets namely: Raw, Name1, Name2, Name3 & Name4 "Raw" sheet contains names only and as for the other sheets, it has below data...

Hi everyone So basically I have a table with zip codes and which county and state they are in (table A). I've simplified the data so there is only one zip code per county per state. I have another list of health data by county and state (table B). So basically what I'd like to do is to have...

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...

Hi all, My research on this topic has only really turned up vlookup which I don't believe that is what I'm after but could be wrong if someone broke it down as to why it would work best. Any way, I have my first workbook called 'barcodes' and the column of interest is K. My second workbook is...

Hi everyone, this is quite a difficult one i think, so here goes. i want to know if its possible to search for an item and relative price based on a customer selection. i have a form that my sales guys use for price changes and i want to link it too our database, now when the select the...

Hi everyone, I've been googling my heart out but still haven't found the VBA code / solution I am after. Let's say I've got 2 spreadsheets named spreadsheet1 and spreadsheet2. In spreadsheet1 there are hundreds of rows with relevant data and I have already turned the autofilter on. The unique...

I have two worksheets. WORKSHEET ONE is a dictionary which has columns for word, definition and clozure. On WORKSHEET TWO I would look users to enter a word in a cell. If that word is in the list of WORKSHEET ONE I would like the value to be entered in WORKSHEET TWO along with the data in B$...

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, Im probably missing something really simple here, but cant see the wood for the trees. I have a spreadsheet with 2 tabs and if in the 2nd tab i want to pull together a delivery note with the data from tab 1. What im looking for is, if cell S6 has a number in it, i want to pull back...

Hi all, I want to know if you can help me out. The data I have is below: <tbody> A B C D E 100020265 -7,671,860.08 7,671,860.08 472023645 100020371 -6,302,466.47 7,671,860.08 472023731 100020370 -2,972,991.07 1,838,071.62 472021113 6200080166 -1,838,071.62 </tbody> I would...

Hello, I'm having trouble with this and I'm hoping somebody here may be able to help. Here is a sample of my data: <tbody> 2011 2011 2011 2011 2012 2012 2012 2012 2013 2013 2013 2013 2014 2014 2014 2014 <tbody> Co.1 </tbody> <tbody> Co.1 </tbody> <tbody> Co.2...

A6:L6 generates either 1 or 0 with a rule that ONLY 1 of the cell in the range (A6:L6) would be equal to 1. A2:L2 also generates values. I want to use the corresponding cell in the range A2:L2 for 1 generated in the A6:L6 for comparison with N2. N2 also generates a value. Output required: O2=If...