Posted to microsoft.public.excel.misc

external usenet poster

Posts: 129

Please help to get cross reference with 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.

With many thanks
Pol

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cross Reference	fgwiii[_2_]	Excel Worksheet Functions	1	July 21st 09 05:06 PM
Cross reference	Kalevi[_2_]	Excel Discussion (Misc queries)	1	May 8th 09 05:33 AM
Cross reference	Edward[_3_]	Excel Discussion (Misc queries)	7	November 10th 08 08:42 AM
cross reference two	auntieb	New Users to Excel	3	September 8th 08 05:17 PM
Cross Reference	Terrance DeBord	Excel Worksheet Functions	1	March 8th 06 04:11 PM

All times are GMT +1. The time now is 08:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us