vlookup

Hello guys i have a data base where i want to first find the column header, 2nd in same column find a certain date, and 3rd return correponding date from same row 1st column. So i have prepared one sample excel file Sheet one - Calc - where user can enter the class and dates Sheet two - Log...

Hi, I want to allocate the financial accounts based on the narration string in the Bank statement, I have created one sample excel workbook with two sheets. There is a "Statement" sheet, which is the snapshot of Bank statement, I want macro or formula to read "Narration" column and pick-up the...

I am building an NBA stat tracking model. As a part of it I am pulling data from each player's Basketball Reference page (each player has their own sheet that is getting data through a query) for the example I am linking to, the player's name is Saddiq Bey (sheet name Bey_Saddiq). Based on that...

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