Different twist on ISNUMBER
Eduardo,
The solution you provided produces "0" and according to HELP has nothing to
do with the issue at hand.
"Multiplies corresponding components in the given arrays, and returns the
sum of those products." ?
Fred
Syntax
"Eduardo" wrote:
Hi
Please check your other post
"fgwiii" wrote:
Hello,
I am currently using the syntax below to achieve a result of "TRUE" or FALSE
on the designation spreadsheet.
ActiveCell.Formula =
"=ISNUMBER(MATCH(D2,[Cindy_PERSONAL.XLS]Sheet1!$F$2:$F$40,0))"
D E F G
Cindy Ren Fred Jon
27109 27598 27028 11208
27206 27600 27076 11210
27210 27649 27386 12210
What I would like to do is be able to return the name of the user (First
cell in each column) if any of the values in their respective columns match
the designation spreadsheet.
Thank you,
|