Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup or similar help
In the same spreadsheet I have the following scenario; Tab "product index" in column A there are names of products like' Apple Orange Banana and etc On column B there are product numbers of these items (side by side) Apple 124568520 Orange 564589700 What I need is when I input customer orders in a tab called "orders" (same spreadsheet, different tab) to get the product numbers when i type the product name. Example I am in "orders" tab col A, cell A1 and typed orange I want the product number to show in B1. Any help? -- Ash |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup or similar help
=VLookup(A1, 'Product Index'!$A$1:$B$10, 2, 0)
Change the Product Index range as necessary. "Ash" wrote: In the same spreadsheet I have the following scenario; Tab "product index" in column A there are names of products like' Apple Orange Banana and etc On column B there are product numbers of these items (side by side) Apple 124568520 Orange 564589700 What I need is when I input customer orders in a tab called "orders" (same spreadsheet, different tab) to get the product numbers when i type the product name. Example I am in "orders" tab col A, cell A1 and typed orange I want the product number to show in B1. Any help? -- Ash |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using VLOOKUP to match similar text? | Excel Worksheet Functions | |||
Similar to Vlookup | Excel Discussion (Misc queries) | |||
Vlookup on a worksheet with similar values | Excel Worksheet Functions | |||
FIND FORMULA SIMILAR TO VLOOKUP FOR NON-ASCENDING VALUES | Excel Worksheet Functions | |||
Vlookup on multiple similar entries / NO VBA | Excel Worksheet Functions |