Column A contains #'s 1-1408 sequentially, Column E has #'s varying 80-33000
non-sequential. Now by using =if(e3:e1408,"27840") this finds this number and
will show in that cell i am putting the formula in. however what i need to
add to this formula is to find and put a reference to a number in the
corresponding column a.
i.e. with above formula "27840" is at E1219, what # is at A1219, and put
that value in the cell the fomula is in.
Thanks for your help!!!