Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return the column reference number of a function result | Excel Discussion (Misc queries) | |||
I want to return a value based on the status of a check box. If . | Excel Worksheet Functions | |||
formula to return the value of a cell based on a looked up true reference | Excel Worksheet Functions | |||
How do I check the conditions of 2 fields to return a result | Excel Discussion (Misc queries) | |||
How do I return an entire row of data from a reference array? | Excel Worksheet Functions |