Sheet 2
Name Coupon Book No. Serial No
A 1 101 110
B 2 111 120
C 3 121 130
D 4 131 140
E 5 141 150
F 6 151 160

in this if I input 125 in sheet 1 i want to see the details related to that number in sheet 1. that is

C 3 121 130

Please give the formula for that.

Thanking you.

Sajeesh