vlook up problem

Hello Gurus, I'm currently have below code DATA 1 Sheet: ITEM 1 ITEM 2 ITEM 3 ITEM 4 DATA 4 001 002 003 Note: In cell E1, that is the Sheet where the data should be look up. Usually, manually filled as there are too many data sheet tabs. In the code below, it...

Hi All, I just need a code for vlookup from another workbook, I tried a lot but's not working properly. I even tried to recorded macro but workbook name changes everytime. Actual requirement is Lookup value is in P column of Loan contract & lookup range SFDC_report.Sheets("SFDC...

Hello Guys, I got some question about the tittle above. I want to make VBA program to match data using IFERROR(VLOOKUP) formulas, and the code like this : Set TableRange = Range("D4:D10000") result = Application.IfError(Application.VLookup(TableRange, Sheet5.Range("A2:C170"), 3, False), "")...

Could anyone help me with the formula for below problem. I need to find the item name with the maximum price in a new column against the name. Attached the excel for the reference. Name Item Name Price Expected Result Formula? Harry A 20 C B 67 C 87 D 87 Tom A1 25 E1...

Hi, this is the vlookup I currently have (that works) VLOOKUP(F2,'\\documents\August\[File Name 30.08.22.xlsm]Sheet 1'!$F:$Z,21,0) The issue is that everyday I have to reset the formula with the prior working day so that it's pulling through the latest comments. I'm trying to create a static...

Hi, I have two workbooks called "A"(Source) and "VLOOKUP_A"(Destination) as shown in the XLBB format. Basically in the VLOOKUP_A workbook, I would like to apply VLOOKUP formula to extract info from the source workbook "A". However, the formula has to be able to recognize the correct date and...

I have two lists of data one has all the pairings (column A) one has my pairings for the next week (column B). I am using vlookup =VLOOKUP(B2,$A$2:$A$191,1,FALSE) to compare the two lists which is working correctly as its showing the names that appear the way in the search list. However some...

(Note: I'm not allowed to install XL2BB on a company computer so pics will have to do) Using the below code to put VLOOKUP in two columns (I & J) has stopped working. The formula IS put in each cell but the results is always #N/A even after verifying the look up value is in the table. I am ONLY...

# Get data After match "Code" Both table, Need Result Table2 we need result in table1= 2.50% (Both Table Name Already in red font) How it Possible ??????

Hi, I've been trying figure out (preferably without INDEX or arrays...my computer is too slow to handle them when dealing with hundreds of rows) a way to perform a VLOOKUP that will return a sub-string (said sub-string defined by the "|" delimiter) that contains specific characters. These...

I have an excel document which consists of two array. Left Array consists of 4 rows which have values from 5-1 (5 beings the highest and 1 being the lowest). The values A,B,C,D,E,F are simplify reference points. W Right Array consists of the cells that corresponds to the cell from the Left...

Hello everyone, I want to show the status of an ID in the previous period in the same row of today's ID. The table looks similar to this A H L M ID (...) Status (...) Current period Previous Period (...) In the column next to previous period I want to show the status of...

Sheet1 SL NO URL Value Country Pages 1 https://www.google.com/ 8 US 23 2 https://www.facebook.com/ 102 UK 8500 3 https://www.amazon.com/ 56 Germany 400 Sheet2 SL No Domain Value Expected Result Value 1 https://www.amazon.com/ =VLOOKUP(B2,Sheet1!A1:E4,3,0) 56 2...

Hi guys, I came across this problem today and I'm not sure how to solve it..I'm sure this is easy for you but I'm a beginner so this is really stressing me out :((( I have two tabs which include: 1: Sales dates, postcodes and number of sales 2: postcodes, store number, store names Each...

Hi, can any one help me with my office batch inventory solution in excel. Dispatch data is available and i need to summarize it in batch summary. Thanks a Lot.

Hi! I am trying to write a function that would use two vlookups, where in the first vlookup there are also IsNumber(Search()) supporting it. What I have written looks like this - IF(ISNUMBER(SEARCH("part of text", d3)),VLOOKUP(D3, 'tab x'!A:B,2,false),VLOOKUP(D3, 'tab x'!A:C,3,FALSE)). As you...

Hi Everyone, I've been trying to get a vlookup formula to work but just realised that vlookup only looks up the first occurrence of a match. How do I make an if function which returns a value if ANY occurrence of a match meets the criteria? i.e. My raw data looks like this: Site ID Name...

Hi all, Apologies if this has been asked before but i cannot find an answer to my question on here or on google. I have the below formula which is a standard vlookup which returns a certain value found for A, B, C etc =IF(VLOOKUP($A7,'CHRISTMAS GIFT...

Hi, I am wondering how I can easily extract wanted data from a spread sheet that is connected to a SQL-database sorting values in random order. Lets say the data is sorted like his: (as you can see, they are not sorted with same intervals all the time) 1 A E 2 Savings...

Hello, I’m trying to display the latest value entered on adifferent tab (pretty much a Vlookup example). In the column on “Tab_2” an employee enters the new amountof mileage driven in the rented car once it’s returned (see example below. Date and Mileage are two different columns)...