vlookup

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

Hey Team, Is it possible to have an IF statement imbedded in your drop down list that automatically fills in your selection depending on a cell value?? In the below example I have a drop down list for my "TYPE". Id like to add an IF statement to my drop down list that would work as follows...

Hi guys! Not sure how to approach this - with lookup and aggregate, an index/match sub or something else. So In the sheet called Empty, when B2 is filled, it populates the Invoice column in D4:D with unique invoice numbers from an external order sheet. The Sales sheet has a list of orders where...

...

I have a table in Excel with one column named employee ID Number. I have a table in MS Word. I want to enter employee ID Number in MS Word table and all other relevant columns populated from Excel table. Is it possible? If not, what other method do you recommend?

I'm trying to see which day of the week had the most sales each month. Column A is # of Sales. I'm currently using this formula =VLOOKUP(MAX(A$44:A$50),A$44:B$50,2,FALSE) Because this formula can only return one value, it will return "Sunday" since it is the first in column B with highest...

Hi, I think this should be a simple one but it doesn't seem to be working for me. There is a list of numbers in column A. On the next tab there is a list of the largest 5 numbers from Column A. The largest 5 numbers are in column D. Next to each of them (in column E). I want to write "Exp" if...

Hi, I want to look up a number that is in column D from column E, and if it is found in a table on a different tab in column A rows 9-109 put the work 'Expenditure' in the lookup cell in column E, and if the number found from the lookup is in column A rows 121-160, put 'Income' in the lookup...

Hi all, What will be the formula if I key in information in table 1 and it auto appear in the table 2 (meeting planner) above. Thank you. Is it combination of V-Lookup + H-Lookup? I was unable to set the formula. Kindly need expert to teach me. Thanks a lot.