Hello.
Ihave a data list containing these columns (See attached excel):
ToolNr, Machine number, Tool name
T1, 5011, Drill 10 mm
T1, 5012, Drill 12 mm
T1, 5013, Drill 11 mm
etc....
IŽd like to make a table with machine numbers and toolnumber like the one below.
5011 5012 5013 5014 5015 5016
T1 Drill 10 mm Drill 12 mm Drill 11 mm
T2
T3
T4
T5
T6
T7
T8
How can I write a function that looks upp the data list and completes the table with the Tool name for each tool number and machine?
I have not found a function with several search critierias.....
/Anders
Bookmarks