vlookup

Greetings, I am using a VBA Script to retrieve a record set from a closed workbook using the .GetRows method. However, it appears the output is contaminated as I am unable to use a VLookup formula on it. Pasting it into Excel and then recopying it is the workaround that I'm using now, which...

I'm completely stumped on my current formula issue. No matter how I try and manipulate the data the result still ends the same with the dreaded #NA error. Worksheet 1: D E...

Hi, I am having the worst time with a basic VLOOKUP. Ive googled and I really feel like it should work but… it doesnt. My main sheet has a list of birds, some specified “barn owl”, some not. My comparison sheet has broad groupings (e.g., owl) My VLOOKUP in B2 on my main sheet looks like...

Hello! So my first problem is as follows; When I make ticket purchases these are given a purchase number from my supplier & a quantity, for example; Purchase number; 34598 QTY; 4 I then use a simple Vlookup formula to filter through which event this ticket is attached to. Once those...

Hi, I have a unique use case so please let me explain. I'm building an xlsx sheet that is used to upload products to eBay via their bulk upload CSV tool. I have various data validation rules, VLOOKUP and CONCAT formulas set up that are making some of the sheet work. The area I need help with...

Hello Excel Gurus, I have sheet 1: Date Invoiced Name Date Planned Include in report Location 01-Aug-23 Event 1 01-Dec-23 Yes New York 01-Sep-23 Event 2 12-Dec-23 No Las Vegas & sheet 2: Date Invoiced Name Description Date Planned Include in report Location...

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