Hello all, I am attempting to determine with a formula in cell g8 if the numerical value in cell g7 is an exact match to one of 61 numerical values in array k1:k61. I've attempted the following formula with no success;
=if(g7=k:k,1,0)
Any advise?
Last edited by mknispel; 01-24-2012 at 04:01 PM.
Hi,
=ISNUMBER(MATCH(G7,K:K,0))+0
Or,
=SIGN(COUNTIF(K:K,G7))
HTH; Haseeb
If your problem is solved, please say so clearly, and mark your thread as Solved:
Forum Rules & How to Mark a thread as SOLVED
That did what I needed, thanks for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks