Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do i Match all COLUMNS?
I need to be able to compare these 5 colums including the location with the
other file. If the 5 colums match exactly with the other file I want a value of YES. When I put in the formula if it matches with Column A from my file with the Column A in the other file it says yes. I want it to match Column A, B, C, D, E with A,B,C,D,E from the orher file. EXAMPLE: MY SHEET: OTHER SHEET: A B C A B C Pen Yellow Chicago ORANGE PINK CHICAGO ORANGE PINK CHICAGO Apple Green New York Apple Red New York Flower Yellow Arizona Now i want all of the 5 colums from my sheet to be cheaked by the other 5 in the other sheet. If they all match including the location i want it to say yes. If 2 coulms match and the location does not match i want it to say No Value or whatever. -- Thnx Siddiqui |
#2
|
|||
|
|||
See your other post
-----Original Message----- I need to be able to compare these 5 colums including the location with the other file. If the 5 colums match exactly with the other file I want a value of YES. When I put in the formula if it matches with Column A from my file with the Column A in the other file it says yes. I want it to match Column A, B, C, D, E with A,B,C,D,E from the orher file. EXAMPLE: MY SHEET: OTHER SHEET: A B C A B C Pen Yellow Chicago ORANGE PINK CHICAGO ORANGE PINK CHICAGO Apple Green New York Apple Red New York Flower Yellow Arizona Now i want all of the 5 colums from my sheet to be cheaked by the other 5 in the other sheet. If they all match including the location i want it to say yes. If 2 coulms match and the location does not match i want it to say No Value or whatever. -- Thnx Siddiqui . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match/ Merge columns | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions | |||
HOW TO MATCH MULTIPLE COLUMNS WITH OR WITHOUT GAPS IN eXCEL ? | Excel Worksheet Functions |