vlookup

I'm facing an issue with the VLOOKUP function when attempting to categorize my customers based on their values. I have a list of customer names in column A and their respective values in column B. Additionally, I have a reference table with categories in column G and their corresponding values...

Can anyone tell me why this shows an incorrect value in the worksheet at the link below? https://www.dropbox.com/scl/fi/t21ab6iiu2tiic829yy72/Prob.xlsx?rlkey=9nk2ks90bmj72lygrouoflr53&dl=1 I cannot figure it out.

Please help me with my workbook as Iam novice to Excel. I have 2 sheets, "STOCKS" and "ORDERLIST" .....I want to automate in Allocation Column the email address of the client matching the criteria of Product_Name,Size and Gender. its should return the email address as unique value, is drop down...

Hi, thanks for help. 1. I am trying to find a max number in a vlookup but my formula is not working (see below) 101 101 3 96 78 So if im trying to find 101 in the table i would do =VLOOKUP,101,table,3,false) but it will bring up 78 but what i need it to...

Dear All, I have a small apparel business setup from home. I want to automate the workbook so as to cut the time of recounting the products and calculations. I have two sheets the first contains my stocks and second Clients orders. I want to automate in Allocation Column where I want a...

Bit of a complex question this time. I want a formula in column E that will return a value from column K, based on whether Column B corresponds with Column J - using cell K2 as a guide. I've been trying to play around with the VLOOKUP formula, but it's clearly not working. Help...

Hello, I am trying to create a macro to copy/paste a generated vLookup formula using a user selected range ("Reference Data") and with the following criteria: - The table array starting column needs to increment by 1 until it reaches the 2nd to last column of the user selected range, but the...

Hi Friends, I need to apply a vlookup or other alternate formula to lookup a price within a range and get the output based on the match. In the below table, I have the price in column A and the value in column B. We have price range data in the D to F column and in the G column I need to put a...

Hi all, I'm trying to get a formula to do exact and partial matches. I use INDEX(...MATCH(...)) to look for exact matches and if fails, then I try to do partial matches using VLOOKUP() but is not showing expected output. The partial match should show the "best match", this is select the...

Hi all, I have what I hope is an easy question. I have the below code for checking if an order is urgent or not. The way it works is that it checks order numbers on available stock in column C in one workbook and compares it to another workbook "HOTSPOTS" containing a list of all the urgent...

I am trying to use VLOOKUP in VBA. I have a workbook with worksheets "DB Load" and "Service Address". I am looking up "Circuit ID's In sheet "DB Load" (column S) and matching that Circuit ID to the worksheet "service address" where column A contains the Circuit ID's and column B in the worksheet...

TASK TASK ID ASSIGNED TO TASK 1 200623175025 ADAM TASK 2 200623175159 JONAS TASK 3 200623184657 JAMES TASK 4 200623184918 ROSSI TASK 5 210623180111 WILLIAN TASK 6 210623191226 JONAS TASK 7 230623151100 JONAS SHEET 1 - TASK GENERATED BY Google FORM, Which we can report as...

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