| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find a number within data by formula
I have some data, which containing is "Reg. no., Roll no., Name, Add. " etc.
in each column, in sheet 1, and another sheet there are some data, which containing is "Reg. no. & Roll No. in seperate column. Now i want to find out fail or pass to put up the "Reg. no. in sheet 1 in another column from sheet 2 by using formula. I would not like to use ctrl+f. is there any formula ? help me |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
find a number within data by formula
You would normally use VLOOKUP for this, or an INDEX/MATCH combination
- both are described well in Excel Help. You would need to describe your data layout in more detail if you want more specific help. Pete On Nov 7, 12:52 pm, capital letter wrote: I have some data, which containing is "Reg. no., Roll no., Name, Add. " etc. in each column, in sheet 1, and another sheet there are some data, which containing is "Reg. no. & Roll No. in seperate column. Now i want to find out fail or pass to put up the "Reg. no. in sheet 1 in another column from sheet 2 by using formula. I would not like to use ctrl+f. is there any formula ? help me |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find a number within data by formula | Excel Worksheet Functions | |||
| Best way to find row number of last row containing data | New Users to Excel | |||
| countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
| What is the Formula to find the Media of a number of cells? | Excel Worksheet Functions | |||
| The formula to find the smallest number in a row not equal to zero | Excel Worksheet Functions | |||
Linear Mode
