| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Want a trace a same values exist in two different sheet
I have two sheet , I want to know if the value in a colomn of a sheet is
exist in other sheet also. say the value is loan number if the same loan number is exist in another sheet than it should be highlighted in the first sheet |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Want a trace a same values exist in two different sheet
Assuming you have loan numbers in Sheet1 ColA and Sheet2 ColA. Try the below
in Sheet1 - Cell B1 =IF(COUNTIF(Sheet2!A:A,A1)0,"Exists","") If this post helps click Yes --------------- Jacob Skaria "Mukesh" wrote: I have two sheet , I want to know if the value in a colomn of a sheet is exist in other sheet also. say the value is loan number if the same loan number is exist in another sheet than it should be highlighted in the first sheet |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Want a trace a same values exist in two different sheet
Wonder ful
Thanku very much sir "Jacob Skaria" wrote: Assuming you have loan numbers in Sheet1 ColA and Sheet2 ColA. Try the below in Sheet1 - Cell B1 =IF(COUNTIF(Sheet2!A:A,A1)0,"Exists","") If this post helps click Yes --------------- Jacob Skaria "Mukesh" wrote: I have two sheet , I want to know if the value in a colomn of a sheet is exist in other sheet also. say the value is loan number if the same loan number is exist in another sheet than it should be highlighted in the first sheet |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| trace dependent tool doesn't work but trace precendent doesn't | Excel Discussion (Misc queries) | |||
| VBA: Make a new sheet if it doesn't exist | Excel Discussion (Misc queries) | |||
| VBA, Make a new sheet if it doesn't exist | Excel Discussion (Misc queries) | |||
| FUNCTIONS FOR TO TRACE THE SAME VALUE IN OTHER CELL OR SHEET | Excel Worksheet Functions | |||
| how can i trace position in marks sheet | Excel Worksheet Functions | |||
Linear Mode
