vlook up

I have a very large excel file that I create every Monday. Many of these tabs have where i am looking at current week and last weeks information. For last week I am looking up from last weeks file. This is a very manual and slow process to have to go change the date for last week each week. Is...

Hello Experts, please kindly help to find a formula, lookup in sheet Assignment column A need to copy to sheet Month View (Calendar) in each day. For example for jun1 have 3 assignments need to copy in month view en the calendar on jun 1 the 3 assignments only.. Thank you for your attention.

Hi, I have plenty of excels and each of them are paired. ( 2 workbooks for a project). I need to compare both workbooks using vlook up formula. I did this by recording macro, and it works for that pair of spreadsheet alone. The issue is, it is recording the spreadsheet name, so if i use that...

Please sir / Madam, I need urgent help with the below; I have two tables. I want to be able to search for the ID from a lookup table and return the one that closely matches the date and time of the main table. Please see sample tables below; Main table ID Date time Vlookup Value 1035...

Hello! I have a question. I have 2 tables in two different sheets. The first table it is like my data base, where all my information is going to be stored. The second table, it is basically a copy of the first one, but this second one is going to show only the records that I am looking for...

Hi, I am new with the VBA, can someone help me, I have made this macro, but the loop across files in a directory runs only in cell G13, and I would like that, once it detects that the value is in a file, pastes it, and continues with the next cell. In other words, my macro result is the value of...

Hi, can someone help me. I need to vlookup across multple worksheets but I can't do it. Sub Macro2() Sheets("BASE").Select Range("G13").Select ActiveCell.FormulaR1C1 = _ "=+VLOOKUP(RC1,[C41.xls]Hoja1!R13:R65536,+COLUMN([C41.xls]Hoja1!R[1]C),FALSE)" Range("G13").Select...

Please see screenshots. Tab 2 is the extract I get from the Information System. I would like tab 1 to update when I paste the info to tab 2. I think one of the limitations could be that it will be done in google sheets.

I have a master workbook with a bunch of question and answers (Columns A-B) and I receive excel questionnaires that have several tabs of questions to answer (questions in column A, blanks for answers in column B). To save time, I am looking for a macro code to add to the blank questionnaire to...

Dear All, Please help me out or suggest me how to vlookup with cell backgrond color, eg. i have sheet1 & 1000 names in column A and i want to vlookup columnB values with multiple cell colors (with formatting) in sheet2 ColumnB according to columnA. please suggest me any shortcut or vlookup...

Hi Team, I have data in sheet1 as below. ABCDEFGHIJ2FirmNumberName1/11/2021ZoneTotal3Gagu Personal3439Adamcova, Milena14:1822:308.20.837.37OST1077.04Gagu Personal3441Balaz, Gabriel14:1922:187.980.837.15TRK571.05Gagu Personal3477Basno, Dorina14:0522:298.40.57.9TRK341.06Gagu...

Good afternoon, Here is the pickle I'm in. Working on applicant tracking report. Trying to automate as much as possible. I'm bring information from 1 sheet to another so things won't have to be imputed twice. Currently using Index and Match to look at the job number to bring over the offer...

Hello, I have a quite intense (some may think its pretty basic) excel document, which shows information within it that I am looking to condense into a pivot/vlookup basis. There are multiple sheets (within a workbook) - so i am trying to have a 'link' feature to do this correctly. its also...

Hello I've been applying a solution posted by Rijnsent to take sales data of finished products and populate a raw materials inventory table. Here is the solution posted by Rijnsent: - https://www.mrexcel.com/board/threads/raw-material-stock-management-using-excel-help.1084422/ Sales of...

Hi, I have below formula where it initially checks if B is empty and if it is empty it does a vlookup with values in respective "A" column. First vlookup is working as expected but need help with 2nd vlookup which is highlighed in red. for 2nd vlookup i need formula that checks values in both...

Hi guys, Please can you help? I know this will be very basic... I just don't know if it's a V-LOOKUP or Index & Match - neither I am good at! Tab 1 is data from data scraping. It pulls in from eBay in CSV (using Parse Hub) and leaves me with several unique rows of data across across a number...

Hello All, i have a table like a following one (of course, mine is bigger) that is coming from a query: Countries 01/01/2020 01/02/2020 01/03/2020 01/04/2020 01/05/2020 Argentina 0 0 3000 2500 0 Australia 0 1000 0 1500 3000 Austria 1500 0 0 0 3000 Belgium 0 0 0 2000 0 France 1000...

Can someone help me with a VBA code for the below scenario. Sheet1 data. 1. Lookup using AB ID - Vlook up with Column B (Sheet2) and column E (Sheet1) for the status, if the result is NA then, 2. Lookup up between Column H (Sheet2) and Column F (sheet1) and in that if there is a version for...

Hello :) I have a database as: ID Start date End date Division 100 15/01/96 17/03/09 1 100 18/03/09 22/05/11 1 100 25/05/11 2/05/18 2 100 3/05/18 7/06/20 2 100 7/06/20 20/12/20 1 101 ... ... ... I would like to reformat the table so that for each ID there is only row with the...

Hey there, First of all, I want to clear that is my first time to dive into excel that deep so please be patient. What I want is to calculate the minimum number of toilet fixtures upon occupancy classification and occupant load. For example: There is a classification called an assembly that...