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!