| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a way to return records?
You're welcome!
Biff "rayteach" wrote in message ... Thank you so much for your response. That makes it much easier to use the VLOOKUP function. -- ray "Biff" wrote: I do not see how this is an advance over copy and paste? Using copy/paste, you'd have to do this every time you want to lookup some data. Using the lookup formulas you do it once by just changing the lookup value. Also, the examples you've been given are rather basic. They can be modified to give them much more capability. For example, you don't need to enter 3 different formulas, one for each column index number: =VLOOKUP($A$1, Products, 2, 0) =VLOOKUP($A$1, Products, 3, 0) =VLOOKUP($A$1, Products, 4, 0) You can write one formula and as you copy it across to other cells, have the column index number automatically increment: =VLOOKUP($A$1, Products, COLUMNS($A:B), 0) Biff "rayteach" wrote in message ... Your formula worked perfectly but, perhaps I am being thick headed, I still need to copy the formula through each cell. I do not see how this is an advance over copy and paste? There is no way to simply type the product code into a cell and then have the rest of the record copied into the adjacent cells? -- ray "Duke Carey" wrote: Name the range that contains your product codes by selecting all the cells, then using InsertNamesDefine and typing in a brief name - let's call it Products Now, in the cells adjacent to the cell where you'll input the product code use (assuming the product code is entered in A1) =VLOOKUP($A$1, Products, 2, 0) The 2 instructs Excel to get whatever is in the second column of the product table, so change this number to 3, 4, etc as you copy it into other cells. The 0 requires an exact match on product code and returns an #NA error if there is no match "rayteach" wrote: I am using Excel XP. I have a spreadsheet with product codes, textual description, price, and extension as the column labels and about 15 records. I want to know if there is a way to (for example) enter the product code of an item in a cell in another worksheet (or a different workbook) and have the complete record of that item be duplicated. ray |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return multiple records matching multiple criteria | Excel Worksheet Functions | |||
| Deleting specific records from a column | Excel Discussion (Misc queries) | |||
| check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
| How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions | |||
| Linking records | Setting up and Configuration of Excel | |||
Threaded Mode
