VLookup - cost of Sales

[akber.431]

can anyone help me in excel

i have 2 worksheet to calculate cost of sales

sheet 1)A Barcode
B Item Name
C) Cost Price


Sheet 2) A) Barcode
B) Item Name
C) Sold Qty
D) Sold Amount
E) Cost Price

to know the cost of Sales i m using theVlookup formula but the function the formula its calculating some cells and rest its showing #N/A

=VLOOKUP(A75:A1500,'Price List'!A75:D1784,3,FALSE)

i m fed with this forumla and please give me any ideas to know the exact of cost sales

any would be appreicated

 

[anglais428]

Looks like you may need to lock your cell range. i.e. adding $ to the range ($A$1:$A$10)

Normally =VLOOKUP(cell,cell_range,column_index,false)

 

[kidwispa]

Why are you using the range A75:A1500 at the start of your vlookup?

Would I be right in thinking that you are inputting the formula given in column E of the second sheet?

 

[akber.431]

Why are you using the range A75:A1500 at the start of your vlookup?

Would I be right in thinking that you are inputting the formula given in column E of the second sheet?

sorry , i copied the formula from cell A75, but i tried from cell A5


yes your r right i put the formula for cost price in column E


in which way i can solve this problem?

 

[akber.431]

Looks like you may need to lock your cell range. i.e. adding $ to the range ($A$1:$A$10)

Normally =VLOOKUP(cell,cell_range,column_index,false)

thnxs for the help
but i couldnt get you
how can i fix the cell range

 

[anglais428]

=VLOOKUP(A75:A1500,'Price List'!A75:D1784,3,FALSE)

change to:

=vlookup(A75,'Price List'!$A$75:$D$1784,3,FALSE)

This locks your range so it doesn't move. You can press F4 to do this

 

[akber.431]

=VLOOKUP(A75:A1500,'Price List'!A75:D1784,3,FALSE)

change to:

=vlookup(A75,'Price List'!$A$75:$D$1784,3,FALSE)

This locks your range so it doesn't move. You can press F4 to do this

thanks for support