Thanks everyone! I'm going to give each of your ideas a shot. Appreciate it!

--
Bobbie Jo


"Steel Monkey" wrote:


If you have about 20 different values i would put them all in a list and
then use a vlookup

If the values you want returned are in E:F ie


E F
5 600
6 700
7 800

In cell A2 you would type =vlookup(B2,E:F,2, FALSE) and then in cell b2
you would type in the number ie 6. This would return 700 in cell A2

Change this around to suit your needs

Let me know how you go


--
Steel Monkey
------------------------------------------------------------------------
Steel Monkey's Profile: http://www.excelforum.com/member.php...o&userid=29051
View this thread: http://www.excelforum.com/showthread...hreadid=572053