matching

Hi lads, Need formula in cell E1 that loops through Columns A & C and if cell value is identical i.e. AB1234X vs AB1234X then it need to compare corresponding adjscent cell values in column B & D to see if they are matching. If they are matching then it needs to return TRUE if not matching then...

I have a userform that when it runs comes up with a blank text box. I want the user to be able to type in the value that they want to lookup, in this case it is a box size, and once they press enter I need it to put all the matching information on the same sheet that I have my macro button that...

I thought this would be simple however, I am finding more difficult than I originally thought. I'll try and keep it simple. I have a single workbook with multiple sheets with data. I am needing a formula to check column A on sheet #1 to columns A,B, and C on sheets #2 and #3 . If the numbers...

Hi everyone, Here are the things that are in each column. Column A - Phone Numbers Column B - Dates Column C - Dates Column D - Record ID's Column E - BLANK Column F - Dates Column G - Phone Numbers I'm trying to write a matching or lookup formula that looks up and down these columns and...

I am looking for a formula. Sheet 1 I have a number in A:1, so in A:2 I need a formula that looks at the number in Sheet 1 A:1, then finds that number on Sheet 2 Column A, When it finds the matching number it displays the new number located in Sheet 2 Column B next to the matching number.

Hi all. I am really rusty on excel so I suspect there is an easy answer to this question, but it currently eludes me. Hopefully I can at least explain what I am trying to do! If sheet 1, cell a2 matches and cell in sheet 2, range a:a then display the matching contents in range c:c (same row...

Hi I have this formula but stuck on the last condition. I want to count based on Client Name in current table where it finds a match to: table1 client name & is not OOS/Lost AND if the country is listed both on table1 matching a table in another sheet which is called 'Prority 1' this last...

I have two spreadsheets: one with hundreds of rows of certain data and the other with thousands of rows of other data. I would like to find the names of the people in the smaller spreadsheet in the larger one. Does anyone know how to do that? I have heard of VLOOKUP but have never used it...

So I have a workbook that I use new daily, I also have a workbook I keep with a runnning collection of the data that I currently send "New" records to every day. I am trying to figure out how to match column A and Column L, then if both are an exact match copy the cell in column T from...

Hi Can someone help me with formula. compare texts from 3 different cells and COLOR which cell is not matching from remaining 2

I want to find out how many of my company's customers are in the Fortune 500. I have both lists, but am not sure how to compare them. Also, how would I handle common words like "the" or "of?" I guess I could do an exact match, but then I might miss close matches, for example, we might have a...

I am looking to match students from the students table to teachers in the Teacher Table. The criteria is the following: A teach can only have one student Student should be matched with a teacher based on the following : Their preferred area in Column N with the Teacher Area in Column C...

I found this and it works for what I need, but how do I get it to list through the entire Column A and how would I get it to output the results in column B or at the very least highlight all the matching results in column A...

I'm using the NOW function to give the time in cell A1 I thought it would be easy to highlight the row which corresponds to the time, by EXACT matching A1 to the column B... but it's not working! What's the best way to get this to work? Thanks for your help!

This is a re-post from another site, since I wasn't having much luck on there: The problem I'm presenting's a little above my VBA skills, so I appreciate any help and ideas. I've pasted a couple of excel sheets to give a general idea of what I'm looking for. Essentially I'm looking for a code...

Hi, Is there a formula that will insert specific text in a cell if any of the cells from column A are equal to the names in Column B? For example Column A contains 123 456 789 Column B contains: 471 871 951 123 456 the last 2 cells in column B (123, and 456) are also in Column A...

Hi all, I am trying to conduct a matching of data between a database of contacts and separate database of enrolments to see whom from the data base has enrolled so far. As representative example of the two sets of data: My data set: <tbody> A B C D E F G 1 First Name Last Name Job title...

I have a list of numbers in column A which are all sorted as follows, and there is other data in columns B to E 43 43 43 56 76 76 83 83 83 83 I only want to see the earliest 2 unique numbers of each. Where there is more than 2 the remaining matching ROWS (A to E)need to be deleted. Therefore...

<tbody> A B C 1 Reference Eligible 2 ABC Yes 3 123 Yes 4 DEF No 5 123 6 123 7 GHI </tbody> Hiya Can anyone help me with the following problem. If a value in Col A is repeated elsewhere in Col A I'd like its corresponding cell in Col B to be...

Hello all, Please see the attached image below. I am having trouble with partial matching & joining together results. As you can see, I have recipes 1-5 in column B, with corresponding days of the week in column A beside them. The letters in column A correspond to days of the week. For...