Find a number

Giganews Newsgroups
Subject: Find a number
Posted by:  Martin Wheeler (ma…@ake.quik.co.nz)
Date: Tue, 14 Oct 2003

xl2000
I want to find the number 1 in range M7:M31 and then copy the corresponding
number in col A to the destination cell, R14.
So if 1 is in M14 and A14 has the number 36 it will be copied to R14.
Any assistance will be greatly appreciated.
Ta,
Martin

Replies