Hi!

Assume the numbers and dollar values are in Sheet1A1:B20.

Sheet2A1 = Bill
Sheet2B1 = 5
Sheet2C1 = formula:

=IF(B1="","",VLOOKUP(B1,Sheet1!A$1:B$20,2,0))

Biff

"Need formula!!"
wrote in message
news:Need.formula.1tq3qc_1123970727.7672@excelforu m-nospam.com...

On worksheet tab 1, I have a list of numbers (col a) ranging from one to
twenty and a dollar value (col b) assigned to each. On the next
worksheet tab I have a list of names in col a and when I put a number
on the next column, I want col c to go to the first worksheet and give
me the corresponding dollar value assigned to that number. I am trying
to use the IF function, but with 20 different values, isn't there
anything simpler?
=IF(a1=1,sheet1!b1,IF(a1=2,sheet1!b2,IF(a1=3,sheet 1!b3...........................
Isn't there a better way?
If not, how does this end?


--
Need formula!!
------------------------------------------------------------------------
Need formula!!'s Profile:
http://www.excelforum.com/member.php...o&userid=26265
View this thread: http://www.excelforum.com/showthread...hreadid=395594