Lookup Value From Sheet2

[dlawrie]

Hi,

I am creating a spreadsheet on Excel 2010 - which by the way I hate th
new layout so confusing.

Anyway on sheet 1 I will be listing all my products details and creatin
barcodes for each product.

On Sheet 2 I have created various table for example I have a table tha
include category type and a Index Number.

What I need to happen on sheet one, when I create a new product unde
the category section I require a drop down list where I pick the chose
category for that product which then returns the Index number into
hidden cell for use in the barcodcode later on.

Can anyone help, i have been searching google for hours now and have go
nowhere

 

[CellShocked]

Hi,

I am creating a spreadsheet on Excel 2010 - which by the way I hate the
new layout so confusing.

Anyway on sheet 1 I will be listing all my products details and creating
barcodes for each product.

On Sheet 2 I have created various table for example I have a table that
include category type and a Index Number.

What I need to happen on sheet one, when I create a new product under
the category section I require a drop down list where I pick the chosen
category for that product which then returns the Index number into a
hidden cell for use in the barcodcode later on.

Can anyone help, i have been searching google for hours now and have got
nowhere.

No reason for a standard vlookup call to fail at getting data from a
hidden column. Maybe I am missing something.