vlookup

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

Hi all, I need in 1 list to find if any values are the same. And thought that Vlookup would be the easiest way to do it? Example Value Name Name Value Name with same value 1 test 1 test 1 1 test 11 2 test 2 test 2 2 3 test 3 test 3 3 4 test 4 test 4 4 5 test...

I have this VLOOKUP for Table3, =IFERROR(VLOOKUP([@Concatenate],'COST TYPE SUMMARY'!$G$2:$H$35,2,FALSE),"0.00"). The rows will vary each month, so I need the formula to auto-populate the new cells when they are added. Is there a way to modify this formula to make that happen?

I have a set of formulas on a separate sheet from where I need them. I have them listed as the person and the formula needed to calculate their specific value. If I try to use a VLOOKUP the equation populates but acts as text and not a formula. I've also tried using an INDIRECT function to add...

I am creating a dynamic dashboard in Excel that would allow users to pull information from another workbook based on the information entered. For example: Cell A1 enters where the workbook is saved: C:\Users\FilePath Cell B1 enters the sheet name: suppose we want to look at sheet1 Cell C1...

Hi Everyone, I'm trying to add an additional condition that doesn't seem to work and I can't figure out why. The new condition is looking at another column for the word "yes". My current formula is following: =IF(AND(COUNTIF(_AG22[Loan ID],[@[Loan ID]]),_AG22[Open...

I am trying to lookup only "DELIVERED" items and have it look up based on tracking number, then return the date it was delivered from Sheet 2 Col L to Sheet 1 Col J, but ONLY if Sheet 1, Col C status says DELIVERED, otherwise leave blank not some error code like Ref# or something else. Also, how...

Having trouble creating a formula that will populate "pay date" based on first criteria "color" and date that falls within date range. Is there a simple way to do this? For exampling hoping to achieve that the formula will start by identifying "BLUE" in Color column, Then return value from Pay...

First off my data is simple- five columns Manufacturer, Type, Description, Function, Category I need to create a user form that allows the user to select Manufacturer and Function from a drop down list. Once they choose manufacturer and function, I need the vlookup to provide all of the valid...

Hi i am using a vlookup and getting #Na errors but for example the value is 51290 and it exists in both areas so should not get a NA error. when i make it '51290 it then finds it and works, is there a faster way in doing this so i dont get the na error?

I have the following data in excel. I would like to derive the "Action" column for a "Person ID" based on the Y or N indicators in the "Value" column and what's in the "Month" column ABCD1Person IDValueMonthAction21N1/1/231st action32Y1/1/2341N2/1/232nd action52N2/1/231st...

I need to dynamically add sheets to my workbook and then add VLookup formulas to my main sheet that reference the newly added sheets. I did this easily with a static name but doing it dynamically has eluded me. I have reviewed an answer to this question on this forum and could not get that to...

Hello, I have a table that lists various "risk factors" in one column and "recommendations" associated with those risk factors in another column. I am hoping I can input all the risk factors into one cell, and then vlookup the recommendations for each risk factor in another single cell. For...

Hello, Would anyone please be able to help me construct the correct formula to create the desired results in the table below? I've not used VLOOKUP before so am a novice at this. Any support would be most gratefully received. Thank you. ABCDEFGHIJKLMNOPQ1Child NameUnique CodeChild Name...

I am trying to figure out how to only look up ABC stock to calculate dividends only. Column B: indicates whether it is DIV, BUY, SELL Column C: name of stock (ABC stock) Column J: $ amount R3 = the lookup value aka stock How do I change this current formula to only include DIV for ABC stock...

Hi I need help filling out the highlighted colum. The goal here is to fill out in Sheet 1, Column C "Closest After Dates in B", with the closet date after column B "Date signed up" by vlooking up to sheet 2 column B "Time", with criteria that Type is either "email", "outbound" or "inbound". I am...

Hi, I would like to sum data in a column based on the results of 2 other columns. Machine 1 Monday 3 Machine 3 Wednesday 2 Machine 2 Monday 5 Machine 1 Thursday 7 Machine 1 Monday 6 So i need to sum column C in a table Machine 1 Count Machine 2 Count Monday Monday...