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?