Excel wizards????

[Merlin66]

I'm no expert with Excel...
but I'd like to have a data entry "box" with a drop down listing of various cameras and link the choice via a look-up table to supply data into say 5 cells ie pixel size, sensor size, dark current etc etc.
These populated cells are then used for various calculations in the spreadsheet.
Can anyone give me some leads????

[peter_4059]

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.

[Merlin66]

Peter,
Thanks for the input.
I've added some comments to the spreadsheet to better explain what I'd like to achieve....

[sheeny]

You might also like to have a look at the VLOOKUP or HLOOKUP commands...

Put all the data about your cameras in a table (a range a the spreadsheet) and use VLOOKUP, say, to extract data to the cells you want.

Al.

[peter_4059]

I've added the necessary functionality - select camera from dropdown box and the other values will update.

[Merlin66]

Al,
I already do that. But I'd like to add the option of a drop down "one click" camera menu which would automatically enter the other data in the other cells.
See the revised spreadsheet for details.....

[peter_4059]

Can't you see the dropdown in cell C1?

[Merlin66]

Peter,
yes!!
100% what I was looking for - many, many thanks.
Greatly appreciated!!