vlookup & if & and

I am currently using VLOOKUP to return a value from one tab to another. =VLOOKUP(E2,Rates!$B$3:$C$57,2,0) I would like to add additional conditions to this formula so that it will look up the values of each cell in column A and B to return the corresponding value from the Rates sheet into...

Hello. I've been using this forum for a decade and this is the first time I've needed to ask a question because there has always been an answer to my question. Please help me figure out how to populate blank cells to the midpoint with the previous value i.e. I have semi random sample points...

Hi all, 2 questions: 1) I have the following setup: I add new files quarterly to my excel file, so Q1 2021, Q2 2021, Q3 2021, Q4 2021, Q1 2022, Q2 2022 etc. Right now I only have one for each year, but I plan to add many more going forward for 2022- Does anybody have a way in which I can...

I'm trying to build a table that lists a broker's volume from largest to smallest (top 10 firms only). If there are only 9 values in the data set, a zero will appear in the row. To grab the volume, from largest to smallest, I'm using =LARGE($B$2:$B$63,1), =LARGE($B$2:$B$63,2)...

I am having an issue with finding the correct syntax to utilize the vlookup where two criteria are met if the first vlookup returns no data. so I was thinking something like find host on datatableA, - if there is an address value (not blank), display it; if not, then look for the host {still on...

Hello there ; If you can help me with a few problems in the code block below, I'd like to be happy. • The searched value does not work if there is no number. I want to find mixed values ​​in text, numbers and text. • I want to search the table on the different page according to the following...

Hello, I'm new here and I've been scouring this forum and the web for a solution to my scheduling conundrum....I have workshop and I want to be able to know what areas will be busy in the coming weeks/months, based on the current demand. So, I have a table where I input new jobs and I want...

Page 1 C372)Ag Non Real Estate C374)City. D375)#loan E375)Balance C375)Ag loan. C376)Ag line Page 2 A1)Ag Non Real Estate. B1)City. C1)Product. D1)Ag loan. E1)4. F1)$480 Ag Non Real Estate. City. Ag line. 3. $350 (same layout as first record) How do I bring back the count and dollars to page...

Hello, I am trying to lookup a data from table 1 to table 2 however, the vlookup is not matching locations and picking up the first role it finds: See below: Column A Column B Column C Column D Column E Column F Column G Column H <colgroup><col><col><col><col><col...

Hi, Hope someone can help. Going round in circles trying to work out how to do a lookup with multiple conditions. Trying to lookup using the customer CGLE300 (H1) to return Description in column F if the ACCT. is 1000 (H2) and the Status is "Final" (H3). Think i should be using vlookup and...

Hi All, I have an extremely complex (well it is to me) question that I am hoping someone can assist me with. I'll go through the scenario. I am trying to gather data by surveying some people. Each question links to a particular category (where I've allocated it either a +1 or a -1 score to...

Hi I have 2 sheets in my workbook. Sheet 1 has list of IDs and incomplete cells in address field. In my sheet 2 I have Another list of addresses that are fully written and I want to mark the ID if I think that it is matches. The address in sheet 2 can repaeat and evertime the same id is to be...

i need to copy values from a table when 2 other conditions are met. Table 1 <tbody> ID COUNTRY TYPE Details AA AZ READ This is used for reading in AZ AB UK Write This is used for writing in UK CD US EDIT This is used for editing in US AA AZ Write This is used for writing in AZ...

i have a dropdown in A1 which is 2 companies, i have data for these companies on 2 separate worksheets. what i would like is, if A1 =company 1 i could have a vlookup for that sheet in tabs A4:D4, but if A1 = company 2 a vlookup to that sheet would be needed for the same range. i have looked at...

Hi, I am new to vba and would greatly appreciate any help I can get. I am comfortable working with excel, however, I feel what am trying to achieve will be much suited for vba. This is my code, ovbiously something is wrong. As I am new to vba I can't seem to figure out what is wrong. I need...

I have a list of asset numbers that are on sheet 1, column A. Then on Sheet 2, column A I have to enter the asset number (not in the same order listed in sheet 1, column a) along with the member its assigned to. However sometimes the asset numbers change... What I would like to have excel do is...

I have two Sheets "DATA" "RAW DATA" In DATA sheets Column A COLUMN B APPLE 10 APPLE 15 APPLE 16.5 BANANA 35 BANANA 20 BANANA 36 ORANGE 45 ORANGE 15 ORANGE 50 In RAW DATA sheet in Column B I have to input...

Hello, I have data with over 50K rows. I'm trying categorize this data for analysis. The data looks like this. <tbody> Orange_Shirt_P $50 Orange_Shirt_C $40 Orange_Shirt_P $10 Orange_Shirt_C $5 some misc data here $70 Black_Shirt_P $20 Black_Shirt_C $19 Black_Shirt_P $12...

I have a time sheet Table that I pull from Share point and it's linked. to fill the table I have 4 criteria that must be met .Any formula I use It gives me zero result and don't show me the actual Time in the time sheet. Can you help me? Employee Name Sales Manager ClockType Date...

Hey Guys! Can someone please help me? I am trying to allocate an ID number (contained in another worksheet) to every unique name in column A. At the moment, The ID numbers of all “Dog Kennels” are the same but they should be different as they reside in different departments. However, I only...