kroz
11-12-2010, 05:02 AM
It looks like i'm better with Macros then with normal formulas. Here's what i'm trying to do and where i am stuck at:
I have a let's say 10 columns table and I'm trying to see if the right part is the same as the left part of my table. To do this i created another column in the left part like so:
A B C D have all values/formulas. Column E has this: "=B&"/"C&"/"D"
I do the same to my right side table:
F G H I have all values/formulas. Column J has this: "=F&"/"G&"/"H"
I then apply a
=IF(NOT(ISNA(VLOOKUP(J10,A:E,5,0))),IF(EXACT(VLOOKUP(J10,A:E,5,0),J10),"Match found","Match not found"),"Value not found")
It wasn't really my idea, i enherited. I want to improve the formula to eliminate the columns E and J.
To do this i need a VLookup that returns 2&3&4 instead of only one value.
Is there another way of comparing that many cells?
I have a let's say 10 columns table and I'm trying to see if the right part is the same as the left part of my table. To do this i created another column in the left part like so:
A B C D have all values/formulas. Column E has this: "=B&"/"C&"/"D"
I do the same to my right side table:
F G H I have all values/formulas. Column J has this: "=F&"/"G&"/"H"
I then apply a
=IF(NOT(ISNA(VLOOKUP(J10,A:E,5,0))),IF(EXACT(VLOOKUP(J10,A:E,5,0),J10),"Match found","Match not found"),"Value not found")
It wasn't really my idea, i enherited. I want to improve the formula to eliminate the columns E and J.
To do this i need a VLookup that returns 2&3&4 instead of only one value.
Is there another way of comparing that many cells?