Looking for an If function, but not really...

[Marcus Fox]

Looking for an If function, but not really... know can only have seven if
functions but need 20. Basically if "1" shows then return the value 4.6, if
"2", show 4.7, if "3" 4.9 (note not 4.8) all the way up to 20. Each value is
defined. Any advice?



Marcus

 

[Niek Otten]

Hi Marcus,

Look at the VLOOKUP() function.

A tutorial can be found here:

http://www.contextures.com/xlFunctions02.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Looking for an If function, but not really... know can only have seven if
| functions but need 20. Basically if "1" shows then return the value 4.6, if
| "2", show 4.7, if "3" 4.9 (note not 4.8) all the way up to 20. Each value is
| defined. Any advice?
|
|
|
| Marcus
|
|

 

[Trevor Shuttleworth]

=IF(OR(A1<1,A1>20),"",CHOOSE(A1,4.6,47,4.9,5.3,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20))

Regards

Trevor

 

[Marcus Fox]

Hi Marcus,

Look at the VLOOKUP() function.

A tutorial can be found here:

http://www.contextures.com/xlFunctions02.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

Thanks, that's what I was looking for.

Marcus