Hello Alfred, another way,
LOOKUP(2,1/EXACT(A2,J$2:J$5),K$2:K$5)
copy down.
Hello Alfred, another way,
LOOKUP(2,1/EXACT(A2,J$2:J$5),K$2:K$5)
copy down.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks