lookup

Hi all, I've scoured the internet for a solution and have tried coming up with a solution myself, but I'm just not proficient enough with VBA to be able to do it (and all of the solutions that I could find online involved a popup input box to manually enter keywords each time). I'm trying to...

Hi guys, trying to fix this issue. The formulas were written by somebody else. This is my formula: =IFERROR(LOOKUP('QCP Review Data'!H10,'Group list'!A:A,'Group list'!B:B),"") Data in Group list A:A are different test codes, and B:B are several groups. So theoretically, the formula should be...

Hello! I need to look up an article number in a table and return a text associated with this number. A pretty easy task it seems, BUT I can't get it right! The workbook has two sheets I recieve article numbers from one program with some content I past this content in "Materiallista". In...

Has anyone tried more detail about speed test for value lookup formulas? I tried myself but I doubt my experiment. Please see my screenshot. The lookup formulas to compare: (1) INDEX-MATCH, (2) INDEX-XMATCH, (3) XLOOKUP. Formula setting to compare: (1) whole column vs fixed range reference...

I have a spreadsheet that populates the data grid based on certain other calculations (which is all working fine) and I want to add a lookup function so that the data is only shown if the first entry in that column was less than 60 days ago. The challenge is that the spreadsheet does not have...

Hello, Column A is filled with string values. Column B is sometimes filled with the value "x". I would like to write VBA code that returns all the string values from column A into an array if they match the "x" value from column B. Anyone knows how to do this? Thanks

Hi All, I need some help with a formula which is not working the way I want it too. I have columns with dates and rows with values, see below: my current formula in column M is: =IFNA(LOOKUP(2,1/((Q10:DA10<>"")*(Q10:DA10<>"Y")),Q10:DA10),"") What it currently does is pick up the last cell...

Hi all, I have a table that I would like to add to a Power Query and then: filter one of the columns based on values that appear in a column in a separate table in a different worksheet add an additional column that gets populated using a lookup against the separate table I've provided some...

Hello all, I've written a transformation to look up a column header in a table and return the number of hours corresponding to that value. The original value in the cell is then divided by this number. The amount of header columns and their names can vary depending on the workbook so it doesn't...

Hi all, Hope you guys are well. Please check the attached pic. I need to find out the value of "Stock Code" from "Table 1" to "Table 2". Is there any ways I can do it? Thanks in advance :)

Hi. Stumped on this for a while. I would like to find all the values of an item in a range like a sort of index-match, then find the trimmed mean of those values, and repeat this process for each of the other items in the range. Attached is a sample sheet showing what i would like. Would be...

Hey, I am looking for some guidance on how I might achieve the following: I have a column (column H) of full addresses, for example: 1234 SW 80th Pl, Miami, FL 33331 On another sheet, I have a list of COUNTIES in column A, and CITY in column B. COUNTY CITY Palm Beach Acacia Villas...

I am using Excel 2016. I would like to do a lookup function that also involved the indirect function. I have multiple worksheets which belong to a coach and are titled accordingly - 'Peter' 'Sally' 'Chris' etc. On my active worksheet I have a table that looks like below: (assume the below...

Hello Excel Experts, I have a potentially novel request: I have 22 sheets with the exact same formatting/cell positions. I would like to grab values from all sheets that meet criteria. If Column C contains "Yes" on any sheet, I would like the sheet name (contained in cell A1), the Building...

Have a different tab for each security setup. Trying to create a sumif formula with the criteria range pulling a tab name from a cell for that specific tab. So for instance have the tab name Acala in cell E38, want the sumif to pull critieria from Acala!C:C, is there a way to make the formula...

Hi, I am trying to make a dispatch note that when you type in the UJN from our project tracker it will pull through the Customer, Plot or Site Information depending on the cell. I have used this formula on a current spreadsheet to show some delivery info at a glance...

A certain company has taken a loan in installments. Depending on the number of years that have passed since the installment was taken, the company has to pay a certain multiple on it. The loan installment that was taken first also gets paid out first. It is possible to make partial repayments...

I enter the daily sales report for each sales person ... it is an updated total every day i am trying to create a monthly tally for all the other information with the spreadsheet but i need it to reference over the course of the whole month, final sales totals can be up to $50,0000 for the month...

Hello, I have tried VLOOKUP, HLOOKUP, and too many others to list. I think it will be easier to show: So, I have a spread sheet with several different hardware and hundreds of serial numbers. i would like to type in the serial number and see the hardware displayed.

Hi there, I was wondering if would be possible to use a cell with comma-separated values that have suffixes (i.e. iterations or repetitions) that in turn translate into the full value in the lookup table. The dataset we use is frankly ugly, but it would be nice if there was a way to make the...