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!!!

Try this:

A1 = number to seach for

=INDEX(A3:A1408,MATCH(A1,E3:E1408,0))

I have a bad feeling about this one! <grin

--
Biff
Microsoft Excel MVP


"v1rt8" wrote in message
...
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!!!

Never mind, finally figured it out using =match(27840,e3:e1408,1). I posted
this in case anyone else needed this formula.

"v1rt8" wrote:

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!!!

I'm not complete clear on what you are asking, but I think this might do it:
=IF(IF(E1372:E1399,"27820")<FALSE,INDIRECT("A"&RO W()))

Use this formula is the same place you would have used
=if(e3:e1408,"27840")

Post back and let me know how it worked.
--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"v1rt8" wrote:

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!!!

T. Not quite sure what the "index" part does, =MATCH(A1,E3:E1408,0) seems
to give me the same answer.


"T. Valko" wrote in message
...
Try this:

A1 = number to seach for

=INDEX(A3:A1408,MATCH(A1,E3:E1408,0))

I have a bad feeling about this one! <grin

--
Biff
Microsoft Excel MVP


"v1rt8" wrote in message
...
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!!!

Judging from the posters reply, I misunderstood what they wanted to do.

I thought they wanted to lookup a value in column E and return the
corresponding value from column A.

--
Biff
Microsoft Excel MVP


"Meebers" wrote in message
...
T. Not quite sure what the "index" part does, =MATCH(A1,E3:E1408,0) seems
to give me the same answer.


"T. Valko" wrote in message
...
Try this:

A1 = number to seach for

=INDEX(A3:A1408,MATCH(A1,E3:E1408,0))

I have a bad feeling about this one! <grin

--
Biff
Microsoft Excel MVP


"v1rt8" wrote in message
...
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!!!

T. Valko you are correct. however 2 hours after original post I was able to
come up with the answer.
I thank all who replied, everyone was very helpfull. Thanks

"T. Valko" wrote:

Judging from the posters reply, I misunderstood what they wanted to do.

I thought they wanted to lookup a value in column E and return the
corresponding value from column A.

--
Biff
Microsoft Excel MVP


"Meebers" wrote in message
...
T. Not quite sure what the "index" part does, =MATCH(A1,E3:E1408,0) seems
to give me the same answer.


"T. Valko" wrote in message
...
Try this:

A1 = number to seach for

=INDEX(A3:A1408,MATCH(A1,E3:E1408,0))

I have a bad feeling about this one! <grin

--
Biff
Microsoft Excel MVP


"v1rt8" wrote in message
...
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!!!