If the SP value is the lookup value, then just use

=VLOOKUP(SP_formula,lookup_Table,column_Offset,Fal se)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"addie" wrote in
message ...

Thanks Bob. It worked.

One more question...

If I wanted to do a vlookup that incorporated that logic, what forumla
could I use?

Addie


--
addie
------------------------------------------------------------------------
addie's Profile:
http://www.excelforum.com/member.php...o&userid=25526
View this thread: http://www.excelforum.com/showthread...hreadid=513868