[Mike Davies]

I was kindly given this formula yto use in my project
=IF(A2=1,L1,IF(A2=2,L2,IF(A2=3,L3,IF(A2=4,L4,IF(A2 =5,L5,IF(A2=6,L6,IF(A2
=7,L7,IF(A2=8,L8,IF(A2=9,L9,"")))))))))
The problem is i need to have 60 IF's but it errors after 9, there is an
example of my workbook at http://massivemike.co.uk/Tickets.htm i need
to input a number on sheet 1 A4 and get trhe name from that number on
sheet 2

Thanks Mike

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[jaf]

See vlookup in help.



--

John

johnf202 at hotmail dot com


"Mike Davies" wrote in message
...
I was kindly given this formula yto use in my project
=IF(A2=1,L1,IF(A2=2,L2,IF(A2=3,L3,IF(A2=4,L4,IF(A2 =5,L5,IF(A2=6,L6,IF(A2
=7,L7,IF(A2=8,L8,IF(A2=9,L9,"")))))))))
The problem is i need to have 60 IF's but it errors after 9, there is an
example of my workbook at http://massivemike.co.uk/Tickets.htm i need
to input a number on sheet 1 A4 and get trhe name from that number on
sheet 2

Thanks Mike

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Tom Ogilvy]

=Indirect("L"&A2)

See additional in answer to one of your multipostings in other Excel groups.

Regards,
Tom Ogilvy

"Mike Davies" wrote in message
...
I was kindly given this formula yto use in my project
=IF(A2=1,L1,IF(A2=2,L2,IF(A2=3,L3,IF(A2=4,L4,IF(A2 =5,L5,IF(A2=6,L6,IF(A2
=7,L7,IF(A2=8,L8,IF(A2=9,L9,"")))))))))
The problem is i need to have 60 IF's but it errors after 9, there is an
example of my workbook at http://massivemike.co.uk/Tickets.htm i need
to input a number on sheet 1 A4 and get trhe name from that number on
sheet 2

Thanks Mike

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!