matching

I'm trying to compare columns of first and last names (A:B) on ws1 with columns (A:B) on ws2. If the name exists on ws2, then I need to copy the value of ws1 columns (I:L) to ws2 columns (D:G) for the matching row.

Hi, I'm not convinced there's a way of doing this without using VBA which I would really like to avoid, but here goes... I have been tasked with matching 2 spreadsheets from entirely different sources. Each is a list of distinct vehicles with a unique identifier (which is proprietary to...

I have a need to match data from one column to another and then post in a third column (received) Using a scanner to read a barcode to post in the second column. Want the number posted to look at column one and find the matching number and then reach to a hidden cell to pick up the (Received)...

Hi guys, Within a workbook I've got a tab(Tab_A) with a list of "Book Tittles" sent it by an external source (20K rows approx). In another tab(Tab_B) I've got my reference list also with "Book Tittles" which I do own. In theory a relevant % of tittles included in the list provided by the...

I am using the following to calculate the mean per row where the ID's are the same. =IF(A4=A3,"",SUMIF(A:A, A4,E:E )/COUNTIF(A:A, A4)) Column A contains my ID's, Column E contains the paid amounts. This works except for the fact that if there are 2, 3, 4 matching ID's it will not populate the...

Not being a coder, I found what I would think to be a pretty simple example of code on the Microsoft support site that compares data in two columns to find duplicates but puts the matching data in the column to the immediate right of the selected column. Cool, but not quite what I need. I was...

I have the first 8 columns in my sheet (A-H) set to desired widths. Does anyone know of any easy way to assign subsequent blocks of 8 (I-P), then Q-X), etc. to widths matching the first 8? In other words, A, I, & Q... would all be 17.57. B, J, R would all be 9.43... Many thanks in...

I have thousands of rows of data that I have to look through to see if there are matching positive and negative numbers matching by ID and then move the matching pair to a different tab. (Or at the very last highlight I have been trying to find an easer way to do this then having to manually do...

Hi, I,m trying to vlookup one cell value with the other. And I got the result also. But I want only one particular result if the cell values are matching. Rest results I want to keep blank even if its matching. For example I have a list of drawing no's in first sheet and second sheet have the...

Hello all, I am trying to match 2 cells and post result of another cell. here is where I am now. I have 100 attribute labels and attribute values in one workbook. Need to extract the matching Item number I lookup and then find and match all attribute labels and values that are relevant to...

I have two sheets of data. Sheet 1 has ID's and sheet 2 has ID'sand zip codes. I need to match the zip codes to the first sheet if there is a matching ID. The two sheetsonly have some matching ID's so I can't just sort them. <colgroup><col width="64" style="width:48pt" span="2">...

I need help with vlookup, I want to be able to type the first letters of a word in and have all matching words come up in the dropdown list, any help would be appreciated thanks.

i want to use VBA to search files in Windows 10 for a keyword and return matching documents as a list. Also the windows search facility I always find buggy, but i am not sure why thank you

Hi I have a question for all that can possibly assist me.... I have a worksheet that returns, or displays unique matching values (on some, or all target columns in a range. Basically: It looks up, or searches the typed-in input value and it compares it against all existing values in another...

hello and thanks for helping Id like to put a formula in Cell E4 of worksheet 2 that shows an "X" if it finds what it is looking for, or stay blank if not found worksheet 2 cell A4 has a value Worksheet 1 range c11:c37 may have 1 matching value in that range if it is found, I would like cell...

Range("B:B,D:D").Select Range("D1").Activate Selection.FormatConditions.AddUniqueValues Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority Selection.FormatConditions(1).DupeUnique = xlDuplicate With Selection.FormatConditions(1).Font .Color...

Good Afternoon, <colgroup><col></colgroup><tbody> =IFERROR(SUMIF('Sales Index'!$C$2:$K$2,B$2,INDEX('Sales Index'!$C$3:$K$200,MATCH($A5,'Sales Index'!$B$3:$B$200,0),0)),0) </tbody> The formula is listed above that is working (index and match) but I have a matrix on another tab that has...

Hello, I am hoping someone can assist me with figuring out a formula that can add a flag in a "NoMatch" type column as displayed below based on a similar set of data. The purpose is to identify where a particular ID has a debit without a matching credit. I assume the fact that the ID can be...

I have two groups of data I am trying working with. In each group, there is a column with a unique value. I am trying to match those values together and then sort so I get a 1-to-1 match on rows. Unfortunately, there are duplicates, so when applying the formula...

Hey Gang, Wasn't sure how to properly word the subject, but let me share the unique scenario. Matching the Unique ID's, I need to check if sheet2 has a value listed. If so, then sheet1 just says "Has Value", otherwise it says "No Value" So in a way, I'm hiding the dollar amounts and replacing...