Compare 2 rows of text and return adj value
 

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?

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!
==============================================


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

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

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


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

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" wrote in message
...
I'm just not getting it. I'll keep trying. Thanks

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


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

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!
==============================================


"Pat DeStasio" wrote in message
...
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" wrote in message
...
I'm just not getting it. I'll keep trying. Thanks

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


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

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


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


"Pat DeStasio" wrote in message
...
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" wrote in message
...
I'm just not getting it. I'll keep trying. Thanks

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


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

Thanks for the feed-back.
--


Regards,

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

"Pat DeStasio" wrote in message
...
that works great.....I thank you very much.


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


"Pat DeStasio" wrote in message
...
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" wrote in message
...
I'm just not getting it. I'll keep trying. Thanks

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


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