vlookup

I'm struggling to take a median of a set of data with multiple criteria I have a set of raw data (Shown Below) I want to find the Median of the data in Row K (Gain) for all the cells where the DEF Call (Row H) is "Base Tommy" AND it's in Hole (Row R) 2 OR 3 OR 4 OR 5. (I don't want the median...

Due to security controls on my system, XL2BB is not an option. Sorry, I really would prefer using that to writing this all out. Below is the destination table (well, one of them) I'm using to capture employee hours per month per department. This department is "AC" and is one of the few that has...

Hi everyone , I need help with a lookup. I have one spreadsheet that has the invoice number, and on a second spreadsheet they combined all the open invoice numbers in a single cell by PO, I need help with a vlookup that can search the column A for the single invoice number and return the PO...

Hi everyone, I have excel spreadsheets saved in a shared dropbox folder so that myself and colleagues can access and update. I have entered formulas to pull in information however its looking on my C drive which obviously returns an error when a colleague opens the spreadsheet. Current...

Hello all, First time posting so please bear with me. I have gone through all the threads that I can find as well as google and YouTube, but to no prevail. I have a vlookup with ISNA formula which is working fine, however the monthly maintenance is quite time consuming and open to human...

I need help in linking images when I enter SKU no in a quotation format. I have two sheets, one is a base file in which SKU no is in B2:B4000 and their corresponding images in E2:E4000 (images are inserted into the cell by copy-paste from PPT/PDF/websites- No URL available). Another sheet is the...

Hello! I am trying to find a formula where, using a static book size (say $1550000) and dollars over goal (say 250000) it will return the % at which commission is applied & can then calculate the annual bonus. For the example this would be 4% as the book size is between $1.5m and $2m, and the...

Hello. Thank you in advance for the assistance. I have a formula that I am trying to update. Currently, the formula references other data points that are on the same worksheet as the formula. The datapoints use vlookups to display the data from other input worksheets. I would like to convert...

hi all, i have this overview: And in my other sheet entitled "XXX" i have this table: I am using this formula to calculate my nominal value in EUR: =IF(J2="EUR";I2;I2*VLOOKUP(J2;'XXX'!AO6:AS7;MATCH(J2;'XXX'!AO6:AS6;0);FALSE)) it should in the case above say 12046,37 * 0,134192, since...

I have a list of words. And now I'm trying to ensure that they are all unique. If I take a copy of that list and RemoveDuplicates, then that removes duplicates, IRREGARDLESS of case. I then place a COUNTIF against that list to find the duplicate which has a count of 2. I then remove all...

Hello Can anyone help me in below attached picture from image 1 is my Data Sheet and 2nd is my daily sheet and i want to auto feel my columns from My DS sheet to daily sheet by month. EXAMPLE if i want jul-23 data in daily jul-23 data line which is 3C, in enter Jul-23 in C3, VLOOKUP formula auto...

Hi all, I have an interesting issue I have been searching far and wide for a solution to no avail. I have 3 employees who are assigned tasks every week. They rotate tasks every week. There are about 30 tasks, but they change every week so one week tasks A, J L K need to be assigned and the next...

I have a tab with employee information on it, with the employee ID starting in C2. I also have a pivot table (tab name is 12345 PIVOT) created from another tab with information that I want to pull into the employee information sheet. The pivot contains the employee ID and two types of costs -...

Hello world, I would like to create a formula that copies all the data from rows which contain "00" in the last two digits of column L, to a new sheet (such as the cells highlighted in yellow). I know I could sort column L by "00" in the last two digits and then copy/paste, but I am trying to...

Hi, I want to have a value of order from the exact file but with the different date range report. I want to match column A, B, C and D from the exact data from the other date range report and get the value of orders (column E) from the other file to this file. Can we achieve that through a...

Hi all, I am looking to create a formula that will look up a list of employees and check to see if they have had any sickness incidents within a month. This will then show eligible or ineligible for their name. I have tried various IF and VLOOKUP methods, and that is where my knowledge ends...

I have a cell suppose B1 = "APPL" I have a Table named "APPL_PRICE" which has Date column & Price Column. I want to VLOOKUP a specific Date( in A1) from the table using the reference of B1 Such as =VLOOKUP($A$1,APPL_PRICE[Date],2,FALSE) But instead i need to use reference of B1...

Hi, I have a question regarding how to create a VBA coding to Vlookup from multiple workbooks. However, if there is no value in the Vlookup, the destination column does not change into "N/A". Hence, I want it to keep it as it is. Here's the coding that I have made: Sub...

Hello, I need help with VLOOKUP in VBA that i havent figured out for weeks now (but im still a beginner too). I have file with 2 sheets - data and calculation. Data sheet has base data as column A has metric name, columns B to O has values but the catch is that criteria values are in rows 1...

Need some help here! Two part question here possibly. I am not very efficient with excel yet so please bear with me! I hope the sample file link works, if not I attached an image where I combined sheet 1 and 2 into one to show an idea of what I am working with. SAMPLE FILE 1. I need to find...