ch90

Posts: n/a

brilliant, many thanks, you make my day.

chris90

"vezerid" wrote:

In worksheet2!D1:
=if(isna(vlookup(C1, worksheet1!$A$1:$B$10, 2, 0)), "", vlookup(C1,
worksheet1!$A$1:$B$10, 2, 0))

HTH
Kostis Vezerides

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
How to compare the lists in two columns & separate odd one ?	Nikhil	Excel Discussion (Misc queries)	2	June 13th 05 02:41 PM
Compare columns	PiedmontJohn	Excel Discussion (Misc queries)	4	January 7th 05 12:08 AM
How do I compare 2 columns in excel from the same spreadsheet	sleyden	Excel Discussion (Misc queries)	1	January 6th 05 01:36 AM
How do I compare two columns on seperate sheets and replace text .	hag400	Excel Worksheet Functions	1	December 28th 04 02:32 PM
Problem with graph ranges	No Such Luck	Charts and Charting in Excel	6	December 3rd 04 01:09 PM

All times are GMT +1. The time now is 05:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us