lookup

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

Hi There, I'm trying to get data ready to move from Excel into a database & I have thousands of rows/columns like the following. For each unique RequestID, I need to return the Year the transaction occurred. Appreciate any guidance!

Hello, I have 4 sheets in a workbook (Sheet1, Sheet2, Sheet3 and Sheet4) On Sheet1 I have a dropdown in B1 to select from a list of fruits. For eg. Apple, Banana, Cantaloupe, Below that dropdown there is a "Store" table with headers Store(A5), Isle(B5), Shelf(C5) On sheets 2,3 and 4, I have...

I have a few items for lookup defined in a range, e.g. Col A is the name and B is the Category. Biscuit Snack Sandwich Snack Milk Beverage Potato Vegetable In another sheet, I have column A with free form text which may have a mention of the words listed above. The text cannot have...

Hello excel experts, I want to grab a list of unit numbers based on criteria in another column. If a row in column G contains "Tax Credit", return the corresponding row value in column B. There is a formula that accomplishes this task: =INDEX(Sheet1!$B$8:$B$86,SMALL(IF("Tax...

Using google sheets, is there a way to look up a value on the vertical & horizontal axes between two numbers? If years of service is 2.8 and company growth is 18.8, how can a lookup formula return 10%? We are rounding down on both years of service & company growth. Company growth: greater...

Hi, Hopefully someone can help. I require a formula in Sheet 1, A1 to search for text contained within Sheet 1, A2. The formula will need to see if the text appears in Sheet 2, C1 to C999 for which it will return the text "NI", or Sheet 3, C1 to C999 for which it will return the text "ROI"...

Hi, I'm trying to find a formula that will help with the below conundrum (sorry for not using the XL2BB, but I don't have permission to download on my work laptop). Basically, The criteria can be found in cell B7, B8 and B9 and the correct result of 3 has been returned in cell B10. What this...

Hi all, I currently have a data set that looks like this: I would like to transpose my information down under columns H-L so that for ALL cells in A that contains "George", their respective cells in columns B-F will be transposed under column H. Likewise the same for all cells that contain...

I have 2 sheets Export (Contains a table) Sheet4 (Contains a range of data) on Export I have an ID ref number in column D. This ID refers to a person on Sheet4 with multiple job start dates back on the Export tab, I also have a shift date in column M ([@Shift_Date]) I want to look...

Hi all, I currently have a large data set, it looks like this: I want to vlookup my data from column A-C into column J-L. However, as the names reappear and sometimes even share the same date (example in A4:B5) a vlookup won't be feasible. The dates are correct in my other table, as well as...

Good afternoon, Our biggest payroll client at our accounting firm has roughly 70 active employees whose payslips and benefits we calculate, and every month their representative asks for a salary map (Objective Table), which today I just learned is done by hand, meaning our accountants have to...