If you set up a Vlookup function in the spreadsheet...(un-used cell)

and identify a cell to paste the lookup value... (lookup function first
term)

you can use Excel to do the lookup and then just "get" the value from
the function cell...

something like:

Cells(1,1)="MyValue"
Return_value=cells(1,2)

where the lookup value is in cell(1,1) and the lookup formula is in
cell(1,2)...


--
weavtennis
------------------------------------------------------------------------
weavtennis's Profile: http://www.excelforum.com/member.php...fo&userid=3634
View this thread: http://www.excelforum.com/showthread...hreadid=514348