| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare column1 with column2
Should actually be:
=if(isnumber(match(B1,A:A,0)),A1,"") -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... in C1 =if(match(B1,A:A,0),A1,"") then drag fill down the column. -- Regards, Tom Ogilvy "myguess21" wrote in message ... Thanks for quick response. No this is string. Just want to search the value from column 2 in column1 if found out put in column 3. -- myguess21 ------------------------------------------------------------------------ myguess21's Profile: http://www.excelforum.com/member.php...o&userid=29578 View this thread: http://www.excelforum.com/showthread...hreadid=492781 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column1 and Column2 | Excel Worksheet Functions | |||
| Column1 and Column2 | Excel Worksheet Functions | |||
| How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
| Compare.xla | Excel Programming | |||
| compare data from one column with another and compare result to yet another | Excel Programming | |||
Threaded Mode
