Enter this in B18:
=VLOOKUP(C29,{2,50;4,105;6,165;8,230},2,0)
Is this what you're looking for?
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Ryan M via OfficeKB.com" wrote in message
...
I am trying to make a spreadsheet for my business and I cant figure out
one
thing. basically if cell C29 reads 2, I need cell B18 to read 50...... if
C29 reads 4, I need B18 to read 105....... if C29 is 6, B18 needs to be
165..
.......... and if C29 is 8, than B18 Needs to be 230.. is there a way
to
do this???
|