LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
doudou
 
Posts: n/a
Default check if reference exists, then return its value or return 0


Hi, thanks for any answer:
In sheet 1, colB, I want to check if ref. in colA also exists in
sheet2col.A, if yes, then return its valu from sheet2col.C, otherwise
(if doesn't exist), return a 0.
Any suggestion from someone ?



--
doudou
------------------------------------------------------------------------
doudou's Profile: http://www.excelforum.com/member.php...o&userid=24047
View this thread: http://www.excelforum.com/showthread...hreadid=376567

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
return the column reference number of a function result Mahendhra Excel Discussion (Misc queries) 2 May 16th 05 12:46 PM
I want to return a value based on the status of a check box. If . JROD Excel Worksheet Functions 1 April 4th 05 08:18 PM
formula to return the value of a cell based on a looked up true reference sarah Excel Worksheet Functions 2 February 2nd 05 08:15 PM
How do I check the conditions of 2 fields to return a result Jimbob Excel Discussion (Misc queries) 3 January 17th 05 11:59 AM
How do I return an entire row of data from a reference array? tvmodica Excel Worksheet Functions 2 January 7th 05 08:52 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"