Index/Match question Need help!

Here's what I can't figure out how to do, I have two lists of checks, each
formatted with first column check number and second column check amount:
CK# Amount CK# Amount
101 525.35 104 425.50
102 225.45 101 525.35
103 400.00 105 115.00
104 425.50 102 225.45
105 115.00 103 400.00

I've searched for a worksheet function that will look at a check number in
the first list, search for it in the second list, and if found, return the
check amount value to a cell.
Grateful for any help.

vlookup should get you there.

"Brian H" <brian.hamilton@smhco.com> wrote in message
news:OiPyLefzFHA.268@TK2MSFTNGP09.phx.gbl...
> Here's what I can't figure out how to do, I have two lists of checks,
> each formatted with first column check number and second column check
> amount:
> CK# Amount CK# Amount
> 101 525.35 104 425.50
> 102 225.45 101 525.35
> 103 400.00 105 115.00
> 104 425.50 102 225.45
> 105 115.00 103 400.00
>
> I've searched for a worksheet function that will look at a check number in
> the first list, search for it in the second list, and if found, return the
> check amount value to a cell.
> Grateful for any help.
>

VLOOKUP() will do exactly what you need. Checkout Excel Help for this
function.
--
Gary's Student


"Brian H" wrote:

> Here's what I can't figure out how to do, I have two lists of checks, each
> formatted with first column check number and second column check amount:
> CK# Amount CK# Amount
> 101 525.35 104 425.50
> 102 225.45 101 525.35
> 103 400.00 105 115.00
> 104 425.50 102 225.45
> 105 115.00 103 400.00
>
> I've searched for a worksheet function that will look at a check number in
> the first list, search for it in the second list, and if found, return the
> check amount value to a cell.
> Grateful for any help.
>
>
>

Take a look at VLOOKUP in Help.

--
HTH

Bob Phillips

"Brian H" <brian.hamilton@smhco.com> wrote in message
news:OiPyLefzFHA.268@TK2MSFTNGP09.phx.gbl...
> Here's what I can't figure out how to do, I have two lists of checks,
each
> formatted with first column check number and second column check amount:
> CK# Amount CK# Amount
> 101 525.35 104 425.50
> 102 225.45 101 525.35
> 103 400.00 105 115.00
> 104 425.50 102 225.45
> 105 115.00 103 400.00
>
> I've searched for a worksheet function that will look at a check number in
> the first list, search for it in the second list, and if found, return the
> check amount value to a cell.
> Grateful for any help.
>
>

With first list in A1 to B100
And second list in Y1 to Z100

Enter this in C2:

=VLOOKUP(A2,$Y$1:$Z$100,2,0)

And copy down as needed.

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Brian H" <brian.hamilton@smhco.com> wrote in message
news:OiPyLefzFHA.268@TK2MSFTNGP09.phx.gbl...
> Here's what I can't figure out how to do, I have two lists of checks,
each
> formatted with first column check number and second column check amount:
> CK# Amount CK# Amount
> 101 525.35 104 425.50
> 102 225.45 101 525.35
> 103 400.00 105 115.00
> 104 425.50 102 225.45
> 105 115.00 103 400.00
>
> I've searched for a worksheet function that will look at a check number in
> the first list, search for it in the second list, and if found, return the
> check amount value to a cell.
> Grateful for any help.
>
>

Thanks! I think I can get this to work!
"RagDyer" <RagDyer@cutoutmsn.com> wrote in message
news:%230KmUpfzFHA.2076@TK2MSFTNGP14.phx.gbl...
> With first list in A1 to B100
> And second list in Y1 to Z100
>
> Enter this in C2:
>
> =VLOOKUP(A2,$Y$1:$Z$100,2,0)
>
> And copy down as needed.
>
> --
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "Brian H" <brian.hamilton@smhco.com> wrote in message
> news:OiPyLefzFHA.268@TK2MSFTNGP09.phx.gbl...
>> Here's what I can't figure out how to do, I have two lists of checks,
> each
>> formatted with first column check number and second column check amount:
>> CK# Amount CK# Amount
>> 101 525.35 104 425.50
>> 102 225.45 101 525.35
>> 103 400.00 105 115.00
>> 104 425.50 102 225.45
>> 105 115.00 103 400.00
>>
>> I've searched for a worksheet function that will look at a check number
>> in
>> the first list, search for it in the second list, and if found, return
>> the
>> check amount value to a cell.
>> Grateful for any help.
>>
>>
>