Formula Problem

[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

 

[jaf]

See vlookup in help.

 

[Tom Ogilvy]

=Indirect("L"&A2)

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

Regards,
Tom Ogilvy