Pulling information from column 3

[sfoust]

This would definitely save me a lot of time...

I have a list of Names in column A and a list of names in Column B (that was imported from a different file). There is a column c of values that i want to be attached to the correct column A (that is, for values that are A=B). I'm describing this rather poorly so here's an example:

A B C
1 2 red
2 3 blue
3 17 green
4 43 yellow
5 6 purple
6 90 teal

So since the value in cell A2 is "2" and it matches B1's "2" value, i would like for the C1 "red" value to be somehow linked to A2. Is this possible? Ie: To have a formula that would transfer the "red" value do say D2 to match up with the A2 "2" value? Thanks for any and all help!

[Bryan Hessey]

This would definitely save me a lot of time...

I have a list of Names in column A and a list of names in Column B (that was imported from a different file). There is a column c of values that i want to be attached to the correct column A (that is, for values that are A=B). I'm describing this rather poorly so here's an example:

A B C
1 2 red
2 3 blue
3 17 green
4 43 yellow
5 6 purple
6 90 teal

So since the value in cell A2 is "2" and it matches B1's "2" value, i would like for the C1 "red" value to be somehow linked to A2. Is this possible? Ie: To have a formula that would transfer the "red" value do say D2 to match up with the A2 "2" value? Thanks for any and all help!

Hi,

in D1 put

=If(IsError(VLookup(A1,B:C,2.False)),"",VLookup(A1,B:C,2.False))

and formula fill that to the end of the data in column A

hth
---

[Maistrye]

You could probably put the following in D1 and drag down:

=IF(ISERROR(VLOOKUP(A1,$B$1:$C$6,2,FALSE)),"",VLOOKUP(A1,$B$1:$C$6,2,FALSE))

Note that you'll have to adjust the range of B1:C6 to include all the values you have in columns B & C.

Hope that helps,
Scott

[sfoust]

Hi,

in D1 put

=If(IsError(VLookup(A1,B1:C1,2,False)),"",VLookup(A500,B500:C500,2,False))

and formula fill that to the end of the data in column A

hth
---

Ok so I tried that, and it ended up looking something like this:
=If(IsError(VLookup(A1,B1:C1,2,False)),"",VLookup(A500,B500:C500,2,False))

But all I am getting is a N/A value error. Did I put something in incorrectly? Thanks again for all of this help!

[Bryan Hessey]

Ok so I tried that, and it ended up looking something like this:
=If(IsError(VLookup(A1,B1:C1,2,False)),"",VLookup(A500,B500:C500,2,False))

But all I am getting is a N/A value error. Did I put something in incorrectly? Thanks again for all of this help!

try

=If(IsError(VLookup(A1,B:C,2.False)),"",VLookup(A1,B:C,2.False))

and if you want to restrict the search to a specific range 1 to 500 then

=If(IsError(VLookup(A1,B$1:C$500,2.False)),"",VLookup(A1,B$1:C$500,2.False))


after formula fill - on row 499 it should look like

=If(IsError(VLookup(A499,B$1:C$500,2.False)),"",VLookup(A499,B$1:C$500,2.False))


hth
---