A good tutorial about VLOOKUP van de found he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jim May" wrote in message ...
| I'm still in Excel 2003, I was just wondering. I've recently written a
| formula with 6 nested if's, and now suddenly need a 7th - Ouch !!
|
| Overall suggestions seem to be to convert to a Vlookup method, but not sure
| at this point how to Set up my scenario table.
|
| Thanks Roger !!
|
|
| "Roger Govier" wrote:
|
| Hi Jim
|
| Yes you can.
| I think the limit is now 256, but I don't think I would want to use the
| limit!!!<bg
|
| --
| Regards
| Roger Govier
|
|
|
| "Jim May" wrote in message
| ...
| Can you now enter more than 7 nested If's in this version?
|
|
|