Compare 2 rows of text and return adj value

[Pat DeStasio]

I have 3 rows if information, 1 row of text with adjacent numbers values. I
want to compare another row of text and where it matches return the adjacent
number. any ideas?

 

[RagDyer]

You could use the Vlookup function.

Check out this web page of Debra Dalgleish which has all the information
you'll need to set this up.

http://www.contextures.com/xlFunctions02.html
--

HTH,

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


I have 3 rows if information, 1 row of text with adjacent numbers values. I
want to compare another row of text and where it matches return the adjacent
number. any ideas?

 

[Pat DeStasio]

I'm just not getting it. I'll keep trying. Thanks

 

[Pat DeStasio]

I don't see how VLOOKUP will work. The two text columns have to match to
return the value in the cell next to the matched text.

 

[RagDyer]

Say that A1 to A20 contains your text, and B1 to B20 contains your numbers.

Say that the *other* column of text is in F1 to F100.

Enter this formula in G1:

=VLOOKUP(F1,$A$1:$B$20,2,0)

And drag down to copy.
--

HTH,

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


I don't see how VLOOKUP will work. The two text columns have to match to
return the value in the cell next to the matched text.

 

[Pat DeStasio]

that works great.....I thank you very much.

Say that A1 to A20 contains your text, and B1 to B20 contains your numbers.

Say that the *other* column of text is in F1 to F100.

Enter this formula in G1:

=VLOOKUP(F1,$A$1:$B$20,2,0)

And drag down to copy.
--

HTH,

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


I don't see how VLOOKUP will work. The two text columns have to match to
return the value in the cell next to the matched text.

 

[RagDyer]

Thanks for the feed-back.
--


Regards,

RD