Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel vlookup
Hi All,
I have a values as follows B C D f1cagprp.p #N/A yfrcpent.p f1caiq.p yfrcptmt.p yfrcptmt.p f1camt.p yfrtvmt.p yfrtvmt.p f1cancmt.p yfstmmrp.p yfstmmrp.p f1capmta.i yfstnen.p yfstnen.p f1captrp.p z xageanl.p zxageanl.p f1catgiq.p zxconwip.p zxconwip.p f1catgmt.p zxrejrep.p zxrejrep.p f1cdlprp.i zxvndanl.p zxvndanl.p f1cdlprp.p #N/A f1chklst.p #N/A f1cholot.p #N/A f1cimdes.p #N/A f1cimilt.p #N/A f1cpcomt.p #N/A i have applied =VLOOKUP(D1,B1:B569,1,FALSE) I want my out put to be if value in B column exists in D column i should get 1 or 0 can any one help me out.... TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
VLOOKUP function in Excel 97 | Excel Worksheet Functions | |||
Vlookup and Indexing in excel | Excel Worksheet Functions |