I want to match the 'lowest miles' number to the three ENG numbers. When matched, I want to display the ENG1/2/3 under ENG
I am working on a project and it has been a while since I've had to use any VBA, so I'm saving the time and asking. I have data on two separate worksheets. I want to compare column B on Sheet 1 with column N on Sheet 2. Any values that do not match between the two columns I would like to...
I am trying to use Index Match to replace Vlookup Function so my textbox displays date format. If I use Vlookup my textbox shows numbers. I tried the below code but it is not displaying the value in the textbox once I run the code. Can I please have your help to make the code work?
Dim TBL As...
I need a formula that will look down column D and match 'TLC' and column C for 'NG' - returning the first EIN match from column A.
I will need to drag down the formula and return the next EIN match from the above criteria, but avoiding any duplicates that have already been returned above...
I have the following test code that is working where column H is equal to what's in column B versus column D
Range("H2:H17") = "=INDEX(D2:D17,MATCH(B2:B17,B2:B17,0))"
Column B Column D Column H
A Test1 Test1
B Test2 Test2
C Test 3 Test3
D Test 4 Test4
E Test 5 Test5
F Test 6...
I have a couple of Index Match formulas that are working well for me but I've realised there may be more than one result to find and I only want the latest date.
My formulas sometimes have two match criteria and two index location, but I'm not sure how to return the highest valued...
I need help in order to change the indirect match formula, I have these data to Match.
#FCE4D6[/URL] "]Roma Sub 1
#FCE4D6[/URL] , align: right"]85000
#FCE4D6[/URL] "]Pisa Sub 98 - 287
#FCE4D6[/URL] , align: right"]176700
Suppose I have several a range of cells, each cell of which contain a string, and I want a function to look at this range and output "FALSE" if all strings in the range are unique from each other and I want it to output the first duplicate it finds if there are at least two cells with the same...
I'm trying to go from the top formula to the bottom one. I have to match H9 (which is a string of 8 characters) to column A which has the same set of information as in column H but with an added number at the end. So I need to be able to match H9 to the leftmost 8 characters in column A. I...
We have the following sheet
Excel 2010 32 bit
Hi I am currently using this formula.
It works great except it does not sum multiple matches it only find the first match in the table. I need...
Pulling off Pivot Table
Looking to do a countif on the entire row based on the part number with greater than or equal to 50.
I have a workbook with multiple sheets. On one sheet, I want to create a search box. This will have three cells to enter the numbers to match to (done via a drop down list). I need the result to look at a table on a different sheet, match the three numbers and return four different...
Using Excel 2000</SPAN></SPAN>
Here the below is my example I need formula for conditional format to highlight result in 3 different forms highlight 2 match, 3 match or 4, for example if I put in the cell C3=1 & in the D3=2 it should highlight in the column C6:D44 all 2...
I have a worksheet called Data. Each row relates to a customer repair. In column C is a part number (3 digit). There are many different part numbers distributed on different rows. If the customer rings to chase the repair the user puts an X in column S against that customer, so there can be...
I just found out an array index/match I wrote awhile back isn't doing what I needed. the formula is
I am in a major pickle at the moment :eeek: Help!
I would like the formula to find the pricing across multiple tabs and the problem is the pricing column.
The pricing column is situated on a different column letter and row number on each tab:
Please see the link below for the...