Biff:
Thanks, this was exactly what I was looking for (a CSE type formula).
Jim
"Biff" wrote in message
...
Hi!
No need for concatenation and a helper. You can
concatenate the fields in the formula.
Assume the last name and amount are in the same columns in
Sheet1 as they are in Sheet2. Entered as an array:
=IF(ISNUMBER(MATCH(B13&G13,Sheet1!B1:B100&Sheet1!
G1:G100,0)),"Yes","No")
Biff
-----Original Message-----
In both sheet1 and sheet2 I have hundreds of records.
60% of the records in sheet1 are also in sheet2.
If I concatenate 2 of the fields "LastName" and "Amt",
can I insert a formula in a helper column (Sheet2)
that will search sheet1 and bring back a "yes" if found,
"no" if not...?
=if(sheet2!B13&G13 = vlookup(sheet1!
$B$5:$K$200, "yes","no")???
ANy help appreciated..
.
|