| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Function
how would i get the description and unit price to automatically appear in th
eproduct thable when an item number is entered in the worksheet |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP Function
the item number is column A and the description and unit price is on another
worksheet called product "bglee31" wrote: how would i get the description and unit price to automatically appear in th eproduct thable when an item number is entered in the worksheet |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP Function
You don't give us a lot to go on, but assuming you enter a product
number in A2, then put these formulae in the cells stated: B2: =VLOOKUP(A2,product!$A$1:$C$1000,2,0) C2: =VLOOKUP(A2,product!$A$1:$C$1000,3,0) This assumes that your data in the product sheet occupies rows 1 to 1000 - adjust if necessary. Hope this helps. Pete On Aug 1, 11:40 pm, bglee31 wrote: the item number is column A and the description and unit price is on another worksheet called product "bglee31" wrote: how would i get the description and unit price to automatically appear in th eproduct thable when an item number is entered in the worksheet- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP Function
Pete
Can i email you what my Spreadsheet looks like "Pete_UK" wrote: You don't give us a lot to go on, but assuming you enter a product number in A2, then put these formulae in the cells stated: B2: =VLOOKUP(A2,product!$A$1:$C$1000,2,0) C2: =VLOOKUP(A2,product!$A$1:$C$1000,3,0) This assumes that your data in the product sheet occupies rows 1 to 1000 - adjust if necessary. Hope this helps. Pete On Aug 1, 11:40 pm, bglee31 wrote: the item number is column A and the description and unit price is on another worksheet called product "bglee31" wrote: how would i get the description and unit price to automatically appear in th eproduct thable when an item number is entered in the worksheet- Hide quoted text - - Show quoted text - |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP Function
Yes, though it is 1:15am here so I won't get to look at it until
tomorrow. Pete On Aug 2, 1:04 am, bglee31 wrote: Pete Can i email you what my Spreadsheet looks like "Pete_UK" wrote: You don't give us a lot to go on, but assuming you enter a product number in A2, then put these formulae in the cells stated: B2: =VLOOKUP(A2,product!$A$1:$C$1000,2,0) C2: =VLOOKUP(A2,product!$A$1:$C$1000,3,0) This assumes that your data in the product sheet occupies rows 1 to 1000 - adjust if necessary. Hope this helps. Pete On Aug 1, 11:40 pm, bglee31 wrote: the item number is column A and the description and unit price is on another worksheet called product "bglee31" wrote: how would i get the description and unit price to automatically appear in th eproduct thable when an item number is entered in the worksheet- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP Function
Email received, and I have sent you back an amended file.
Pete On Aug 2, 1:17 am, Pete_UK wrote: Yes, though it is 1:15am here so I won't get to look at it until tomorrow. Pete On Aug 2, 1:04 am, bglee31 wrote: Pete Can i email you what my Spreadsheet looks like "Pete_UK" wrote: You don't give us a lot to go on, but assuming you enter a product number in A2, then put these formulae in the cells stated: B2: =VLOOKUP(A2,product!$A$1:$C$1000,2,0) C2: =VLOOKUP(A2,product!$A$1:$C$1000,3,0) This assumes that your data in the product sheet occupies rows 1 to 1000 - adjust if necessary. Hope this helps. Pete On Aug 1, 11:40 pm, bglee31 wrote: the item number is column A and the description and unit price is on another worksheet called product "bglee31" wrote: how would i get the description and unit price to automatically appear in th eproduct thable when an item number is entered in the worksheet- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedded If Function in a Vlookup Function | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
| how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
| I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions | |||
Hybrid Mode
