Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup Value From Sheet2
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. |
#2
|
|||
|
|||
Quote:
Could you post an example worksheet? (I hated the new layout of Excel 2007/10 at first too, but once you get used to it, it's not so bad) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Value From Sheet2
On Sun, 14 Oct 2012 20:08:34 +0000, dlawrie
wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
macro to print sheet2 without open sheet2 | Excel Discussion (Misc queries) | |||
A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updated | Excel Programming | |||
Sheets(2) = 2nd tab? = Sheet2 (Sheet2)? | Excel Programming | |||
how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ | Excel Discussion (Misc queries) |