customer details and till staff

[B4L4KS]

hi

i have a problem where i cant get staff details to appear in specific cells,

this is the staff details

this is where i want them to appear, but i need it so the name of a staff member appears where it says name of staff and the till number they are on to appear next to the name of staff on staff details, but they need to appear in the box with data from the picture at the bottom of the page in accordance to the number of tills that have to be open, picture at the bottom

any help will be great-full

many thanks

kristian

 

[GlennUK]

Do you mean that you want to look up a till number in the first table, and get the associated name for that till? If so, use INDEX(MATCH type of formulas.