Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formulas
I am trying to create a formula for an invoice. When a specific part number
is entered into the cell that in the next cell the description is pulled up. All the information is on a seperate worksheet?? Ahhhh! Help Please this is driving me nuts!! -- TMansell |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formulas
If you have part Nos and descriptions in Sheet2, columns A:B, and enter part
No in Sheet1 A2 then =VLOOKUP(A2,Sheet2!A:B,2,FALSE) returns the description. Regards, Stefi €˛TMansell€¯ ezt Ć*rta: I am trying to create a formula for an invoice. When a specific part number is entered into the cell that in the next cell the description is pulled up. All the information is on a seperate worksheet?? Ahhhh! Help Please this is driving me nuts!! -- TMansell |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formulas
Assuming you already have a table somewhere of part#s and descriptions, say
on Sheet2!A1:B100, then you can enter this in Sheet1, which also assumes your part # is in A4 and you want the description to automatically fill in in B4: In cell B4 of Sheet1: =IF(A4="","",VLOOKUP(A4,Sheet2!$A$1:$B$100,2,FALSE )) and fill down... Bob Umlas Excel MVP "TMansell" wrote in message ... I am trying to create a formula for an invoice. When a specific part number is entered into the cell that in the next cell the description is pulled up. All the information is on a seperate worksheet?? Ahhhh! Help Please this is driving me nuts!! -- TMansell |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formulas
Hi,
A little more detail might be nice. This sounds like a lookup issue but what does your data look like in the separate sheet? What is the organization of the data in that sheet, is there a unique line for each part number? are the part numbers in the first column? is the description to the left or right of the part number? How many part numbers are listed - are we talking 10 or 1,000,000? What version of Excel? What do you want to do if the part number is not found? For example, in 2007 you might write =IFERROR(VLOOKUP(A1,Sheet2!A1:C1000,3,FALSE),"") but this would not work in 2003. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "TMansell" wrote: I am trying to create a formula for an invoice. When a specific part number is entered into the cell that in the next cell the description is pulled up. All the information is on a seperate worksheet?? Ahhhh! Help Please this is driving me nuts!! -- TMansell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Formulas | Excel Worksheet Functions | |||
ms-excel guidence notes, complete formulas in excel, How to runmacros in Ms excel | Excel Discussion (Misc queries) | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Copying formulas from Excel 2003 to Excel 2007 | Excel Discussion (Misc queries) | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) |