| 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 |
|
#2
|
|||
|
|||
|
=IF(ISERROR(VLOOKUP(A1,Sheet2!$A$1:$C$2,3,FALSE)), 0,VLOOKUP(A1,Sheet2!$A$1:$C$2,3,FALSE))
you'll need to change Sheet2!$A$1:$C$2 to whatever range you are working with on sheet2. for example, if you have 80 rows in your table change to sheet2!$A$1:$C$80. see help for VLOOKUP function - it can give you additional details about the arguments. "doudou" wrote: 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 |
| Reply |
| 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 | |||
Hybrid Mode
