M
MNike
I've posted an example of my workbook at
http://massivemike.co.uk/Tickets.htm
i need to put a number in column 1 sheet 1 and the name
from that number on sheet 2 will appear in the appropriate
cell, The formula i used works ok with numbers but i get
an error with text #VALUE, does anyone have a different
way of doing it or know where i going wrong
Thanks Mike
I can email it to you if req
http://massivemike.co.uk/Tickets.htm
i need to put a number in column 1 sheet 1 and the name
from that number on sheet 2 will appear in the appropriate
cell, The formula i used works ok with numbers but i get
an error with text #VALUE, does anyone have a different
way of doing it or know where i going wrong
Thanks Mike
I can email it to you if req