copy data from sheet1 based on the value in sheet2

[ssbhatban]

Dear Friends

I have a excel sheet ( master) where in in column B there will be register no, in column C there will be student name & in column D there will be father name

now in i have one more sheet ( derived) in which i will enter a register no in column B & if that register no is there in column B of master sheet then it should pull the corresponding student name & father name from column C & D & put it in the same place in derived sheet

it would be great if somebody can help me with it

 

[Colo]

It seems that the Vlookup function works. If you would like to hide errors, need to add more, but better to start with a simple way for your learning.

Book1
	A	B	C	D
1	SL.No	REGSTER NO	STUDENT NAME	FATHER NAME
2	1	1260224	S Name1	F Name1
3	2	1072527	S Name2	F Name2
4	3	1191230	S Name3	F Name3
Delivered

Cell Formulas
Range	Formula
C2:C4	C2	=VLOOKUP(B2,Master!$B$1:$D$12,2,FALSE)
D2:D4	D2	=VLOOKUP(B2,Master!$B$1:$D$12,3,FALSE)

 

[ssbhatban]

Working fine thanks

Just wanted to to know what is the advantage of using $ .even without $ it is working

 

[Colo]

With $, it's called the absolute reference. It's handy when the referred range is fixed. For details, have a look at the following link.

Switch between relative, absolute, and mixed references - Microsoft Support

Use absolute or relative cell references in formulas, or a mix of both.

support.microsoft.com

 

[ssbhatban]

Thank you very much