Find in a Range and return a value

[LightRose]

I have a spreadsheet that has something similar to thefollowing:<o></o>

<o></o>​	Find this number in range A1:B4<o></o>​	Bring back Officer who issued Ticket (ticket assigned to)<o></o>​
A<o></o>​	B<o></o>​	C<o></o>​	D<o></o>​	E<o></o>​
Beg. Ticket No.<o></o>​	End Ticket No.<o></o>​	Book Assigned to Officer<o></o>​	Ticket No. Issued<o></o>​	Issuing Officer<o></o>​
10000100<o></o>	10000125<o></o>	Ted<o></o>​	10000135<o></o>	Brad<o></o>​
10000126<o></o>	10000150<o></o>	Brad<o></o>​	10000176<o></o>	Mike<o></o>​
10000151<o></o>	10000175<o></o>	John<o></o>​	10000110<o></o>	Ted<o></o>​
10000176<o></o>	10000200<o></o>	Mike<o></o>​	10000125<o></o>	<o></o>​

<tbody>
</tbody>

<o></o>
I know how to do aVLookup and a HLookup, but I am not grasping the range to bring back what I need.<o></o>

 

[philwojo]

Sorry wrong thread.

 

[LightRose]

OK, I'm new here, can you tell met where I need to post this?
Thank you

 

[philwojo]

Sorry I meant I replied to the wrong thread, you are good, someone else should be able to help you, I just misposted.

 

[MARZIOTULLIO]

	A​	B​	C​	D​	E​
1​	Beg. Ticket No.​	End Ticket No.​	Book Assigned to Officer​	Ticket No. Issued​	Issuing Officer​
2​	10000100​	10000125​	Ted​	10000135​	Brad
3​	10000126​	10000150​	Brad​	10000176​	Mike
4​	10000151​	10000175​	John​	10000110​	Ted
5​	10000176​	10000200​	Mike​	10000125​	Ted

<tbody>
</tbody>

e2=VLOOKUP($D2,$A$2:$C$5,3) copy down

 

[LightRose]

Thank you, I did my VLOOKUP wrong and thought it needed to be a range formula. This worked! Thank you again.

 

[MARZIOTULLIO]

you are welcome

 

[LightRose]

Hi Marziotullio,

For some reason when I copy the formula down, when I get to other tickets that have come in they are still saying from the first Officer in the first cell. I understand what you are saying but don't know where I am going wrong.

 

[LightRose]

Got it! They had a row of tickets that was not in ascending order. Thank you again.