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,sheet1!b3...........................
Isn't there a better way?
If not, how does this end?
Bookmarks