lookup value and return result in column to left

Since my array is not in ascending order, my result is NA
I am attempting to get a value in column A to be the result of searching in
colum B based on the lookup value in cell G1. My column B is not in ascending
order. Column A is a ranking column of 1-44. (In other words, I am seraching
for John Doe in column B. The result should be the ranking position on in the
same row of column A)

Try this:

=INDEX(A1:A100,MATCH(G1,B1:B100,0))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mark M" <Mark [email protected]> wrote in message
news:[email protected]...
> Since my array is not in ascending order, my result is NA
> I am attempting to get a value in column A to be the result of searching
in
> colum B based on the lookup value in cell G1. My column B is not in
ascending
> order. Column A is a ranking column of 1-44. (In other words, I am
seraching
> for John Doe in column B. The result should be the ranking position on in
the
> same row of column A)

AWESOME!! It worked. Thank You!

"Ragdyer" wrote:

> Try this:
>
> =INDEX(A1:A100,MATCH(G1,B1:B100,0))
>
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Mark M" <Mark [email protected]> wrote in message
> news:[email protected]...
> > Since my array is not in ascending order, my result is NA
> > I am attempting to get a value in column A to be the result of searching
> in
> > colum B based on the lookup value in cell G1. My column B is not in
> ascending
> > order. Column A is a ranking column of 1-44. (In other words, I am
> seraching
> > for John Doe in column B. The result should be the ranking position on in
> the
> > same row of column A)
>
>

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mark M" <[email protected]> wrote in message
news:[email protected]...
> AWESOME!! It worked. Thank You!
>
> "Ragdyer" wrote:
>
> > Try this:
> >
> > =INDEX(A1:A100,MATCH(G1,B1:B100,0))
> >
> > --
> > HTH,
> >
> > RD
> >
>
> --------------------------------------------------------------------------
-
> > Please keep all correspondence within the NewsGroup, so all may benefit
!
>
> --------------------------------------------------------------------------
-
> > "Mark M" <Mark [email protected]> wrote in message
> > news:[email protected]...
> > > Since my array is not in ascending order, my result is NA
> > > I am attempting to get a value in column A to be the result of
searching
> > in
> > > colum B based on the lookup value in cell G1. My column B is not in
> > ascending
> > > order. Column A is a ranking column of 1-44. (In other words, I am
> > seraching
> > > for John Doe in column B. The result should be the ranking position on
in
> > the
> > > same row of column A)
> >
> >