One follow up question...
Say instead of having it show a "3" if the match is true, could I have it
show another value from the detail worksheet? In column E of my detail
worksheet I have a record number. How could I show that value instead of a
"3"?
"Max" wrote:
Try this variation which might better suit the possible underlying data types
(text & text numbers mixed with real numbers) that you're trying to match.
Array-entered with CSE, as befo
=IF(ISNUMBER(MATCH(1,(TRIM(Sheet1!$A$2:$A$100)=A2& "")*(TRIM(Sheet1!$B$2:$B$100)=B2&"")*(TRIM(Sheet1! $C$2:$C$100)=C2&""),0)),3,0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Secret Squirrel" wrote:
Hi Max,
Thanks for that code. But I'm getting all 0's for everything. Could it be
that the detail in column A is a combination of text and numbers? Is the code
only going to work if the data is all numbers?