Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To find the same price in another sheet
I have a column with name 'Item' which contain the code of the product.
Another sheet ( same file) contain code and profit. Sheet1 item A1 200 300 400 500 600 Sheet2 Item preofit A1 B1 200 60 500 10 600 20 400 10 I have to find profit for the same item from sheet2 and to write in sheet1 column b1. Please help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
To find the same price in another sheet
Use the Excels Help to learn about the function: VLOOKUP
Micky "pol" wrote: I have a column with name 'Item' which contain the code of the product. Another sheet ( same file) contain code and profit. Sheet1 item A1 200 300 400 500 600 Sheet2 Item preofit A1 B1 200 60 500 10 600 20 400 10 I have to find profit for the same item from sheet2 and to write in sheet1 column b1. Please help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
To find the same price in another sheet
I have just put up an EXCEL 2007 file for you at:-
http://www.pierrefondes.com/ Item number 93 (towards the top of my home page at the time of posting). If my comments have helped please hit Yes. Thanks. "pol" wrote: I have a column with name 'Item' which contain the code of the product. Another sheet ( same file) contain code and profit. Sheet1 item A1 200 300 400 500 600 Sheet2 Item preofit A1 B1 200 60 500 10 600 20 400 10 I have to find profit for the same item from sheet2 and to write in sheet1 column b1. Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find the original price? | Excel Discussion (Misc queries) | |||
whole price sheet change | Excel Worksheet Functions | |||
How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
How do I set up a price sheet in excel. | Excel Worksheet Functions | |||
find selling price of bonds | Excel Worksheet Functions |