[peter_4059 (Peter)]

Is this what you are trying to do Ken - select camera in cell E8 and corresponding values for camera data are in d8, g8, h8. Table of data is in e1:h6. You use data validation to define the list for the dropdown box to select the camera.