Re: Formula to Enter Part Number, cell equals discription and price o.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Max (demechanik_at_yahoo.com)
Date: 09/29/04 

Date: Wed, 29 Sep 2004 11:24:31 +0800

One way ..

Assuming your reference data is
in Sheet1, cols A to C, data from row2 down, viz.:

Part# Name Cost
1001 Spider $45.00
1002 ATX B $38.00
1003 Demon $69.00
etc

In Sheet2
-------------
With the same headers in A1:C1, viz.:
Part# Name Cost

and you'll list the Part#s in A2 down

Put in B2:

=IF(ISNA(MATCH($A2,Sheet1!$A:$A,0)),"",VLOOKUP($A2,Sheet1!$A:$C,COLUMN(B1),0
))

Copy B2 across to C2, and fill down to a safe max
expected number of rows, say down to C100 ?

Format col C as currency

Blanks "" will be returned for any unmatched items in col A
(instead of #NAs) 

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----
"Melange" <Melange@discussions.microsoft.com> wrote in message
news:7FD29865-4E32-4D6C-A57F-A72910027440@microsoft.com...
> I have a Parts list on one worksheet (Computer Parts). I want to be able
to
> enter a part number on another worksheet to figure the cost of building a
PC
> i. e.
> Case: Part Number=1001 Spiderman Case  Cost $45.00
> Case: Part Number=1002 ATX Beige Case   Cost $38.00
> Case: Part Number=1003 Demon Case        Cost $69.00
>
> I want to enter the "Part Number" of each item (Case, Hard Drive,
> Motherboard, etc) and have the discription and price enter automatically
in
> the cells I setup. I can't get the Formula right! Can anyone help? Thank
you.

Relevant Pages

  • Re: End of the World
    ... Viz top tip: ... a fraction of the cost! ... LOL I don't have one so small but I would hate one of those huge great ...
    (uk.media.tv.misc)
  • Re: Faulty Acorn A540 PSU
    ... but I got a PC one from CPC (not the normal 'square' ATX ... type) and fitted the board inside the RPC PSU case. ... Cost under 30 quid. ...
    (comp.sys.acorn.hardware)
  • Re: Where I buy most of my pewter stuff
    ... > um, ATX? ... > for mother boards, if it was in an atx it will fit in this atx ... There is standard ATX and Micro ATX... ... I get everything at 5% above cost. ...
    (alt.gathering.rainbow)