Creating a cost/consumer speadsheet

[deaula]

So, I have been looking to make a spreadsheet to track my costs and profits automatically.
In cells A2-A100 I have my items I am selling in a drop down menu.
In cells B2-B100 I want the cost I pay for the item automatically selected depending on the item selected in the A column.
In cells C2-C100 I want the cost I sell it it automatically selected depending on the item selected in the A column.

Could anyone help me? I have been looking through some excel functions and formula help sites but I cant find anything, and I am not that computer smart...

 

[Michael M]

do you have a table of the Items AND their costs anywhere in the spreadsheet ??
If so where is the table ....Sheet name, Cell range ??
If so you can use a VLOOKUP formula to populate column B
Column C will simply be Column B multiplied by, say 1.25, for 25% markup on the cost

 

[deaula]

Sheet 2, Cells A1-10 are the items names
Sheet 2, Cells B1-10 are the costs

 

[deaula]

So I found the VLookup formula, but I can't figure it out.... in the first block I choose the left most of my table on sheet 1, on the 2nd row I select the item name column on sheet 2?

 

[Michael M]

In B2 on Sheet1 place this formula

=VLOOKUP(A2,Sheet2!$A$1:$B$10,2,0)

and drag down as far as required

 

[deaula]

In B2 on Sheet1 place this formula

=VLOOKUP(A2,Sheet2!$A$1:$B$10,2,0)

and drag down as far as required

So I just tried that and it is giving me a circular error warning...

Is there a way I can send you my file through email or something? I am at work and cant upload anything except to gmail... =\

 

[deaula]

Nevermind I got it!!! Thanks!!!!!

 

[Michael M]

Glad you got it sorted...

 

[deaula]

cheers! WOOO!