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

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

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

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