Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding matching codes in two different columns
I have two columns of codes - Column A has 10400 codes with prices that go to
that specific code in Column B. Then I have Column C which has a selection of 1400 of those codes from Column A. Is there a way that I can take the Column C codes and compare them to those in Column A and if there is a match put just those that match on a different on a different worksheet - giving me a new list of those 1400 codes with the correlating prices? Example: A B C 0400T 275.00 0500T 0500T 6.50 24900 12000 44.00 66000 24900 339.00 H0876 66000 112.00 99823 10.00 H0876 13.85 After run would have: A B 0500T 6.50 24900 339.00 66000 112.00 H0876 13.85 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding matching codes in two different columns
Move (or copy) the values from column C to column A of a new worksheet.
Then use a formula like: =vlookup(a1,'originalsheetnamehere'!a:b,2,false) and drag down those rows. Then you could convert to values (edit|copy, edit|paste special|values) and sort the results so that the N/A's are grouped together. Then delete those rows with errors. ps. Be careful with those numbers. If one location is text (like '12000) and the other is a real number (12000), then there excel won't find a match--even though you probably expected it. Debra Dalgleish has lots of notes on troubleshooting =vlookup(): http://contextures.com/xlFunctions02.html#Trouble TRMercer wrote: I have two columns of codes - Column A has 10400 codes with prices that go to that specific code in Column B. Then I have Column C which has a selection of 1400 of those codes from Column A. Is there a way that I can take the Column C codes and compare them to those in Column A and if there is a match put just those that match on a different on a different worksheet - giving me a new list of those 1400 codes with the correlating prices? Example: A B C 0400T 275.00 0500T 0500T 6.50 24900 12000 44.00 66000 24900 339.00 H0876 66000 112.00 99823 10.00 H0876 13.85 After run would have: A B 0500T 6.50 24900 339.00 66000 112.00 H0876 13.85 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Duplicate UPC Codes in 1 Column | Excel Discussion (Misc queries) | |||
vlookup - matching where codes are not exact | Excel Discussion (Misc queries) | |||
Comparing two columns and finding matching names | Excel Worksheet Functions | |||
finding percentages of a list of zip codes | Excel Discussion (Misc queries) | |||
Finding Matching Symbols in 2 Columns | Excel Worksheet Functions |