vlook up help

I am in need of a formula which will search for a specific value in a column of cells that may contain more than one value in each cell. e.g. A B C D E F 1 ROLE RESULT ROLE RESULT 2 897 BONUS 563, 897 BONUS 3 167 #N/A 4 897 BONUS 5 637, 598, 897 BONUS 6...

I have a list with unique references. I want to look up these references on another data sheet, where they might appear multiple times and with different result data. Using vlookup only returns the first instance of that reference being found and I need to know them all, or at least total of...

Hi, I am trying to create a vlookup based on multiple criteria but not quite sure how best to do this. I tried this formula but doesn't output how I want it to. =VLOOKUP(G1055&B1055,'App Lookup'!$G$23:$J$36,3) Below is my lookup table, tab called App Lookup. My App_Data tab needs to be...

Hello, I have created a master inventory excel sheet to keep track of all my inventory. It consists of 4 tabs; Lists, Shipping Log, Receiving Log, and Inventory On my Inventory sheet, I am wanting to add any merchandise from the receiving log to the previous inventory on the 'Lists' tab. At...

Excel formula for multiple matches. Kindly help to find a formula in G3 and G4. I have data in column B and C, I wanted to match it with column E and F. However vlookup does not work as there are multiple matches. I wanted a result of True/False if B and C contains the values in E and F...

Hi sorry for the question but I have been unable to find a clear answer..... Is it ok to use a partial selection of a spreadsheet for a vlookup for example the spreadsheet is 20 columns long the data your matching against is column 5 and the info you want to pull is column 11 is it ok to...

Hoping someone can help me out!!! I want to search for a value from one column, into another column and output a different column....if that makes any sense. I have a column of receivers numbers that detected. I have another column of all possible receivers, followed by 2 more columns of the...

I'm working with two separate tables. 1. Table A lives on a tab called 'Proposed Pieces'. It contains lots of data including a column called "DURATION" containing a cell with a value in it. In this table there is also a column called "G" with grades from 0 to 8. 2. Table B lives on a tab...

Hello, I need help, if I have a case to do a vlookup with 2 categories so that if criteria one is not found then it will be searched for with criteria two. I want to find "price" with the first criteria "code", if can't find it then look for the second criterion "product". Please help, what is...

Hi, I have a question and would kindly ask for your help to figure this out. Table 1, represents the date in which each product was acquired and the price paid for it. I want to perform a search in this table so it returns the price of a product to its closest registered date. TABLE 1...

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

I have created a Vlookup formula on one of the columns on a workbook. This Vlookup will look for part numbers on the other Workbook and paste the ones that are matching and others that are not matching will showup as NA I want to change this formula in a way that. Anything that Matches should...

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

Hi guys I was wondering if there was a way to do a Vlookup with an IF, AND, perhaps even an ISBLANK statement and what that formula would look like for the following scenario. I am trying to create a worksheet that will allow me to type in a restaurant ID and it tell me if It is closed on...

Dear all, bare with me. I have a spreadsheet with two sheets: Sheet 1: called Data (where data is input into column A. column B will return a value from vlookup of sheet 2 Sheet 2: called roles. Column B in Sheet 1 will need to return the value of column B in Sheet 2 based on a lookup...

I am building a tool that the user can use to create a UTM based on criteria they have selected. I have created a list validation for 2 fields that depending on which the previous selection. The selection is dynamic so what ever is chosen as a "Channel" then the "Description" list will only...

I have been playing with INDEX Match and Vlookup, however am struggling to solve my problem, I normally end up using 10+ multiple column filters to reach my results. Made an example below where I input 3 variables and wish to find a Row which matches all the criteria, in the example the results...

HI, I WANT EACH SHEET TO BE AUTO UPDATED BY THE MATER SHEET IF I ENTER REF CODE ON THE TOP OF THE SHEET. FOR EG, IS IT POOSIBLE THAT "ADG" SHEET AUTO UPDATED BY MASTER SHEET IF I ENTER "ADG" IN CELL "B1" OF ADG SHEET? IN MDG SHEET , I WANT NAME AND ALL OTHER DETAILS TO BE EXTRACTED FROM MASTER...