reference 2 cells

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.

I tried creating a table to aid a manufacturing process. Where technicians perform some test and record the results. One of the column (unit #) auto populates based on other column entries of the table. The unit # column helps keep track since a technician is supposed to test 14 units in a...

Hello, I have a report that produces a spreadsheet where column B has last names and column C has first names. There are many tabs like this and that number of tabs may vary. On a new tab named "Name Filter" I have set up Column A for Last names and a Column B for First names. What I want to...

Hi, I have sales for Target product A, B, C, D and then sales for Amazon product A, B, Walmart product A, D. How do I calculate what were the percentage of sales for each customer/product referring to Target/ specific product? Thank you in advance. Lena

There are 3 Sheets in this file:"Mapping", "Data", and "Pivot" 1st Sheet is "Mapping" <tbody> Level Name Name Sector ID Company Sector ID Sector Applicability ID Link Link Name Solution Name Mapping 1 Mapping 1 Revenue Mapping 2 Mapping 2 Revenue 1 Dairy Farms 43523 D43523 Dairy...

Hello All, I have attached a sheet and I need to know how I can get the last day alive as it is different for each player but relatively close by the game over date. There are about 500 players so manual work seems a little daunting. Please help, so what I was thinking was to get the Game over...

Hi Helpers, I'm not sure if this is indeed possible, but thought i'd give it a go as you all have been so helpful in the past. I have two tables in two separate worksheets ("WKST1" and "INV2") as shown below. INV2 references WKST1. In Column D of INV2 I am using a SUMIF equation to total all...

Hi Helpers, I'm not sure if this is indeed possible, but thought i'd give it a go as you all have been so helpful in the past. I have two tables in two separate worksheets ("WKST1" and "INV2") as shown below. INV2 references WKST1. In Column D of INV2 I am using a SUMIF equation to total all...

Hi, I need some help adding a formula in a cell that is within brackets. On a cell, I type in "{" but then try to reference another cell (ie: c4). For some reason, I am not allowed to add neither an formula nor any sort of reference to another cell. Anyone know how I can get around this? I...

I have had posted a similar issue earlier, but it did not solve my problem. Therefore, I try again. My Pivot table gets data from a OLAP Cube. Using the macrorecorder i got this code by setting a new date in the filter and then update the Pivot table. I can manually change the date and it will...

I have this simple formula, which I want to drag down the page, to pick up the "MAX of M11:M15" across several worksheets =MAX(Room1 Dashboard'!M11:M15) The "Room1" part obviously refers to a worksheet and also this "Room1" text is in cell A10 on the sheet where the formula is. How do I...

I'm new here so good day all! Could do with a bit of assistance if anyone has time? I have tried searching Google and these forums for an answer I could apply to the situation ... Ie. Inside these threads: ...but I'm not quite getting the logic behind this Index match...