Hello

I am trying to create a register/log of equipment for our office. I have the data in a s/sheet and not sure what formula I need to use. Each piece of equipment has an ID, serial number, description and service date. I want to create a log where my engineers can just enter the ID reference in one cell and it pulls the serial number, description and service date into the cells going across. I am guessing I will need some sort of look up table. any ideas please?