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
Have a look at the function VLOOKUP. Then come back and tell us the layout
of your data in more detail so we can better help you. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "capital letter" wrote in message ... 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 | |||
formula to find how many cell have a number between 2 numbers. | 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 |