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?