Vlookup

**barnesy1977** · 07-15-2010, 09:50 AM

Hi there,

I've just stumbled upon this forum - wish I'd have known about it sooner!

I've spent some time now trying to get a formula correct using the VLOOKUP command, and I'm hoping someone here may be able to kindly assist.

I have 2 spreadsheets, one giving me a summary of items sold for the month 'SALES SUMMARY.XLS' (but not including my purchase cost of each item), the other s/sheet is a definitive list my purchase costs for all items I sell 'PRICE LIST.XLS'.

What I'm hoping to do, is in order for me to calculate my end of month profit, I'd like my purchase cost for each item to be 'pulled in' from PRICE LIST in to SALES SUMMARY rather than me manually entering in each one. Note that SALES SUMMARY will have many entries for the same item rather than say one entry for an item with a quantity of 5 for example. Also, the layout of the s/sheets do not match, for example, PRICE LIST lists ALL of the items I sell, whereas SALES SUMMARY will just include items that I have sold. Therefore, for example row 20 on the sales s/sheet could be 'Item abc' and row 20 on the price list s/sheet' could be for 'Item xyz'.

What I need the Forumula to do, is, within SALES SUMMARY, look at the item sold in Column C and then search for this same item description (which will match exactly) in Column B of PRICE LIST, and then 'pull' the item cost from Column C of PRICE LIST and input this value into Column K of the SALES SUMMARY.

Hope this makes sense! I'd be very grateful of any help or advice anyone could offer.

Many thanks in anticipation.
David

**mojo249** · 07-15-2010, 04:58 PM

David

It'll be easier to follow what you're trying to do if you upload your workbook (edited if it's confidential).

Dion

**barnesy1977** · 07-16-2010, 04:58 AM

Oh sorry I didn't realise I could do this. I'll upload the files just now..
Thanks for the reply.
David

**barnesy1977** · 07-16-2010, 05:06 AM

Originally Posted by mojo249

David

It'll be easier to follow what you're trying to do if you upload your workbook (edited if it's confidential).

Dion

I've attached the two files and highlighted the relevant columns. I hope this makes sense ??

Many thanks again in anticpation
David

**mojo249** · 07-17-2010, 07:32 PM

Hi David

With both workbooks open, enter the following formula into cell K3 of Sales Summary.xls

=VLOOKUP(C3,'[PRICE LIST.xls]FileExchange_Response_8009981'!$B$3:$C$26,2,0)

Then copy and paste it down column K.

Regards

Dion