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 |
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 |
All times are GMT +1. The time now is 11:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com