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

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