vlook up

I have a code that run the index match and vlookup function, but the problem is that the data I receive is not always the same (sometimes only 3 or 5). When I run the code, the code always ask me to update the value of the unavailable sheets. here's my code Sub Function() Dim ws As Worksheet...

Have been trying different solutions without avail: Sheet 1 importing fire extinguisher inspections - Each fire Ext will get inspected once a month Sheet 2 used for tracking purposes Bring over date inspected then will do some conditional formatting based on info The date inspected is a range...

Hi all, I currently have two tables. Table 1 includes a patient's Unique ID and when they visited the hospital (Hospital Visit). In Table 2, there is also the Unique ID, but instead of Hospital Visit I have the date that the patient's primary doctor called to follow up with the patient after...

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