K
Keith R
I'm sure there is a way to do this, I'm just having trouble with the syntax.
On Sheet1, I have some values in Columns A and C
On Sheet 2, I have some values in Column D and J.
For any given row, I need to locate where in the other sheet the value in
Sheet1(A) matches the value in Sheet2(D) /and/ the value in Sheet1(C)
matches the value in Sheet2(J).
These sheets will be continuously updated and sorted by other folks, so I
need to stay away from more complicated solutions like using an extra column
to concatenate A&C in Sheet1 and a column to concatenate D&J in Sheet2, then
match against those- I'm trying to craft a match statement that will include
the concatenation in the formula itself.
=MATCH(D2&"."&J2,('Raw'!A1:A65000)&"."&('Raw'!A1:C65000),FALSE)
There is the possibility of an overlap in the concatenated strings, so I'm
also adding a character that never shows up in the raw reports to ensure
that I don't confuse "cat" & "stick" with "cats" and "tick"; instead I'll
compare cat.stick with cats.tick and realize they don't match.
Any ideas?
Thanks!
Keith
On Sheet1, I have some values in Columns A and C
On Sheet 2, I have some values in Column D and J.
For any given row, I need to locate where in the other sheet the value in
Sheet1(A) matches the value in Sheet2(D) /and/ the value in Sheet1(C)
matches the value in Sheet2(J).
These sheets will be continuously updated and sorted by other folks, so I
need to stay away from more complicated solutions like using an extra column
to concatenate A&C in Sheet1 and a column to concatenate D&J in Sheet2, then
match against those- I'm trying to craft a match statement that will include
the concatenation in the formula itself.
=MATCH(D2&"."&J2,('Raw'!A1:A65000)&"."&('Raw'!A1:C65000),FALSE)
There is the possibility of an overlap in the concatenated strings, so I'm
also adding a character that never shows up in the raw reports to ensure
that I don't confuse "cat" & "stick" with "cats" and "tick"; instead I'll
compare cat.stick with cats.tick and realize they don't match.
Any ideas?
Thanks!
Keith