lookup

I am unable to find a solution to this issue. We have a file where we have multiple header columns and it is dynamic in a sense. Every month we can have new rows and new columns to the dataset. As seen in example photo below I am trying to lookup number for specific cell by row column headers...

Hi There, I cant figure this out how to get this to work. I have searched and tried so many existing solutions with no success. Any help would be much appreciated! Basically, what I want is populate the reference from column B to column K, by finding the value from column J in the range C2:H5.

Hi, I have built a stock list for which part numbers are in Column B (ITEM CODE) and purchase price is in Column E (PURCHASE PRICE). Values increase over time therefore I require when an item is booked out to search for the most recent (lowest) value within Column E (PURCHASE PRICE), and add...

Hi I'm looking to find formula to return a value in sheet 2 after searching for a specific product code and month in sheet 1 and matched to the date in sheet 1 for example find the price paid for an ingredient in October 24 Thanks in advance

Sheet1 has a list of vehicles that are booked for maintenance as follows: Week NumberDateVehicleMaintenanceComments 4214/10/2024ABC1InspectionDrop off early 4215/10/2024ABC3ServiceNightshift 4401/11/2024XYZ20MOTAfternoon Sheet2 needs to draw the relative information from sheet1 for...

Sorry for the uninformative title; I'm not sure what to call the thing I'm trying to accomplish. I'm importing data from a PDF and hope to rearrange them into a more useful structure. I have a list of widgets, grouped by the subwidgets they're made of. So the initial import looks something like...

I'm working with a dataset that has two columns: Transaction (Column A) and Client ID (Column B). I'm aiming to extract the Client ID values associated with a specific Transaction from Column A. For example, if I select Transaction 100000223, I want to retrieve the corresponding Client ID...

Hi everyone 😊 I still have a lot to learn about DAX and have become stuck trying to develop a measure that will filter down my source table to a single row by using values in two columns and return the (text) value from a different, specified column. I have two measures that filter a table and...

Hi. I'm looking for an Excel formula that will do the following based on the table below: Column A Column B Apples No Apples Yes Oranges No Oranges No Oranges Yes Peaches No Peaches No I need a formula that will look at all the lines of Apples and if any of the lines has a...

Hi, I'll try to explain this as best I can... I can't share the sheet as it contains sensitive information. I have a table with over a thousand rows full of text, and I am interested in analyzing it based on the final 3 columns. All cells in those columns contain one word. There are only 4...

Hi All. I am struggling with a problem using VBA code. I am self taught using helpful sites like this and YouTube videos. I am trying to write a line of code that will search a table of data based on a cell and change the status of a another cell. So the user will fill out the form below and...

I have a data set that includes alternate SKU's for products. The alternate SKU's may be in any one of 31 different columns. I have a list of alternate SKU's that I want to look for i the range. When found, I want the formula to return the corresponding value in a different column. This will be...

Hello, I need help with the following please. We get reports with hundreds of lines and I need to verify the error descriptions to catalogue and process errors. Only problem is the criteria is very specific and appears at different parts of string within the cell. Please see image attached to...

I need to lookup & return an interest rate between date ranges. Any date between June 1, 2020 - March 31, 2022; return 2.00% Any date between April 1, 2022 - June 30, 2023; return 3.00% data table 2.00% 6/1/2020 3/31/2022 3.00% 4/1/2022 6/30/2023 3.92% 7/1/2023 12/31/2023 5.33%...

Hi, I am trying to extract all the countries that each product is sold in. It should work for all values (including duplicates) and not just the first value. I am not sure why it's returning product name and not the market name. I have presented the problem below and the solution (hand...

I've successfully used the below formula several places in my spreadsheet. However, when I point it to a cell range that has formulas in it, it only works for the value in cell G5. In the first row, the below formula points to cells w/calculations and only returns the last number in the row if...

As an example see the 2 sample sheets below. They are silly examples but this is similar to what I need to accomplish. I have a value that is text in an activities column and if there is any match in the text to a lookup value, in the lookup table, then it should return it's corresponding value...

Hi, we have the data in sheet1 and sheet2 and using index and match formula, its working fine but we don't want to drag and drop formula from C2:C4 and again we have used formula in D2:D4, there is any formula from which we can get desired result so that don't do drop down SHEET1 125024568765...

I am creating a booking system with the logic of slots availability But when I select the slot from the gallery it doesn't fill the form I already input Gallery.Selected also tried with LookUp('Data Source',ID=Gallery.Selected.ID) and it doesn't work either

Hi All, My issue is probably simple, but Im in a brain fog! I have 2 columns, in A, I have a list of lesson numbers, and in B a list of unique subject IDs. Example 1 1.1 1 1.2 1 1.3 2 1.4 2 1.5 3 1.6 3 1.7 1 1.8 1 1.9 2 1.10 What I want to do is return only those...