| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and Return
Is it possible to find a number in col.A which is also found in col.C
Then in colB show the corresponding code shown in col.D http://www.cadwax.com/excel.jpg Many thanks Keith |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find and Return
Maybe this in column B and drag down
=IF(ISERROR(FIND(A2,C2,1)),"",D2) Mike On 12 Oct, 14:20, "kreffell" <u38188@uwe wrote: Is it possible to find a number in col.A which is also found in col.C Then in colB show the corresponding code shown in col.D http://www.cadwax.com/excel.jpg Many thanks Keith |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find and return adjacent value | Excel Discussion (Misc queries) | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| Find a value, return the value of another cell | Excel Discussion (Misc queries) | |||
| find & return value | Excel Discussion (Misc queries) | |||
| find formula and return value | Excel Discussion (Misc queries) | |||
Linear Mode
