Not sure which formula to use
 

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

Not sure which formula to use
 

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

Not sure which formula to use
 

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

Not sure which formula to use
 

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

Not sure which formula to use
 

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

Not sure which formula to use
 

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

Not sure which formula to use
 

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