View Single Post
Old 08-04-2017, 10:20 AM   #37
firebug
Powerplay Quarterback
 
firebug's Avatar
 
Join Date: Aug 2002
Location: Mayor of McKenzie Towne
Exp:
Default

Quote:
Originally Posted by Weitz View Post
Thanks for the help guys!

I am trying the nested way there, and I can't seem to get it to work.

this is my formula:

=IF(1,$O$117,IF(2,$O$118,IF(3,$O$119,IF(4,$O$120,I F(5,$O$121,IF(6,$O$122,0))))))

All it returns is the value for 1.

Sorry I am awful with excel.

Wait I just realized it doesn't make sense ha.

Cool Got it to work with this:

=IF(N4=1,$O$117,IF(N4=2,$O$118,IF(N4=3,$O$119,IF(N 4=4,$O$120,IF(N4=5,$O$121,IF(N4=6,$O$122,0))))))
You'll kick yourself when you realize how simple vlookups are.

http://excelcentral.com/excel2013/ex...-in-excel.html
__________________
"Teach a man to reason, and he'll think for a lifetime"

~P^2
firebug is offline   Reply With Quote
The Following User Says Thank You to firebug For This Useful Post: