I have 2 worksheets in which I have to copy one column of cells from one to the other. The problem is that the "main" worksheet lists nearly 3,500 clients and I have to copy numbers into the "main" worksheet on weekly basis from another worksheet that lists only about 1,100 of those 3,500 clients.
Both client lists are in alphabetical order, but I obviously cannot just copy one column into the other, because then the numbers won't be matching the correct clients.
I have two columns one is web addresses and the other is email addresses but the rows do not line up. I was hoping that since the second half of the email address matches the web address I could somehow sort them so that the email address column and web address column match up. Here is an example but keep in mind that this list is about 9k long and this is just a sampling so you may not see any in this example that match. Also I may have more than one email address per website.
Now i have one excel sheet with two separet sheets in it ( Sheet 1 ) and ( Sheet 2 ) . I have in sheet 1 a column A with material codes and ColB is discreption and Col C IS Prices . But in Sheet 2 Col D is materila Code and Col I is a price .
the recordes in sheet 1 are around 11000 but in sheet 2 are around 2200 where the sheet 2 has a specific materials from sheet 1 .
Now i want to update the prices in sheet 2 from sheet 1 for each item after confirm that the materila code in sheet 2 equal in sheet 1 so copy the price from sheet 1 to sheet 2
Sheet 2 is old prices and sheet 1 has new prices so i need update the new prices in sheet 2
I have 2 workbooks (workbook1 & workbook2). Information in column A and column N must match both workbooks per row/ cell (ie. if A2 and N2 in workbook1 match workbook2, copy information from 3 other columns (S, T, U from from workbook1 into workbook2 - cells S2, T2, U2). Workbook2 may have information in column S, T, U, but I need to over-write it with the information from workbook1. If the information does not match per that row/cell (ie. A2 in both worksheets are the same, but N2, they are not, so go to the next line that does match and copy the information into worksheet2). I do not want to use a V- lookup for this problem. I really need a marco.
I am trying to do a (what I thought was a) simple lookup involving 2 columns. Pls see attached example. I am trying to find the "?" values, by matching column A&B of the input to the Data columns and returning the $$$ column.
I thought this wouldve been a piece of cake but its got me stumped!
I have a worksheet that has four columns. FName LName FName1 LNanme1. The data doe snot match between the columns... but I need to know which are in both columns.
I need to write a formula that will allow me to compare the LName with LName1 and give me some type of indication there is a match (1, yes, etc.). Ideally, after confirming there is a match, It would create another verification that FName and FName1 also match, but that is not necessary.
Column A is an ID for manufacturers. Column B is the manufacturer name. Column C is the order in which the manufacturers appear. There are duplicates in column C only. They are supposed to be there, and they must remain there. I need column C to match up with the IDs in Column A so it can look like this:
A B C D 1 a a 1 2 b a 1 3 c b 2 4 d b 2 5 e b 2 6 f c 3 7 g d 4
I basically have a list of 4000 names in one column (A) and an extract from a report containg 26000 names, again in one column (B). I need to see which of the 4,000 names in (A) appear in the column (B) from the report.
How can I do something to either line up the names, or make them change colour or something so I can see the matches?
I need column F to be matched to column E, i want to see how many user id's from column F are in column E and for them to be highlighted in column E. note that the user id's might reflect more than once in column E. See attached..
Column A has customer name, columns B,C,D has corresponding sales data for that month. Column E is blank. Column F has has customer name. Column G,H,I has the same corresponding sales data for the next month.
Although Column A and F both have customer names, there are many changes month over month with the addition and deletion of certain customers so the rows do not match up exactly. Is there a quick way to have the rows match up according to customer names in column A and F and then sort them alpabetically?
Currently my list looks like this: Jan Feb A A B C D D F E H F L G M H
I would like it to look like this: Jan Feb A A B C D D E F F G H H L M
The code will go through each line of data checking to see if it can find a match. If not, the cells will be highlighted yellow. It checks from both sides, first checks sheet 1 compared to sheet 2, then sheet 2 compared to sheet 1. That should encompass the variations between the 2 sheets.
If a number in cell M1 is also anywhere in column A (column A has unique numbers), then cell W1 (date) should equal the content of cell V (also date) in the row that that number appears in column A. If M1 is blank (or there is no match in column A), then W1 should equal V1.
I have one excel file which is kind of a database. Now I need to lookup two columns in that file, currently, they are columns A and G, and then copy the value in column H on that row to another worksheet. Because the "database" file is pretty big, I cannot simply go through each row and compare the values. Is there an easier way for this? I checked other posts in this forum and notice other people suggested "lookup" function, but I don't exactly understand that answer.
i did find a thread concerning my question but the topic was closed & the OPs best answer had been edited & removed for some reason...
i'm comparing annual pro sports stats for a project & want to do a vlookup contingent on pairs of columns matching between two sheets. ie if a first AND last name in one sheet match a first and last name in a second sheet then fill in x statistic. i dont know VB or anything, but i assume this can be done w/ a pretty simple formula