Formula Problem

  • Thread starter Thread starter Mike Davies
  • Start date Start date
M

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
 
=Indirect("L"&A2)

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

Regards,
Tom Ogilvy
 
Back
Top