Simple find data function

[Gmhlref]

I have decided to try and create a workbook for truck driving keeping track of all the loads I have done. I have a few pages and have a switchboard kindve page. I want to be able to type in on the switchboard page a load number and it will retrieve the load data.....

Is that easy or to complicated

 

[Gerald Higgins]

Hi, welcome to the board.

This is relatively easy to do, and there are several ways of doing it, but it's difficult to give precise details without knowing more about how your data is set up.

But take a look at the VLOOKUP function, which is probably a good way of doing it.
LOOKUP, HLOOKUP, and MATCH/INDEX may also be useful.