Find in a Range and return a value

[LightRose]

I have a spreadsheet that has something similar to thefollowing:<o></o>
[TABLE="class: MsoTableGrid"]
<tbody>[TR]
[TD="colspan: 3"]

<o></o>​

[/TD]
[TD="width: 163, bgcolor: transparent"]

Find this number in range A1:B4<o></o>​

[/TD]
[TD="width: 151, bgcolor: transparent"]

Bring back Officer who issued Ticket
(ticket assigned to)<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 122, bgcolor: transparent"]

A<o></o>​

[/TD]
[TD="width: 114, bgcolor: transparent"]

B<o></o>​

[/TD]
[TD="width: 90, bgcolor: transparent"]

C<o></o>​

[/TD]
[TD="width: 163, bgcolor: transparent"]

D<o></o>​

[/TD]
[TD="width: 151, bgcolor: transparent"]

E<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 122, bgcolor: transparent"]

Beg. Ticket No.<o></o>​

[/TD]
[TD="width: 114, bgcolor: transparent"]

End Ticket No.<o></o>​

[/TD]
[TD="width: 90, bgcolor: transparent"]

Book Assigned to Officer<o></o>​

[/TD]
[TD="width: 163, bgcolor: transparent"]

Ticket No. Issued<o></o>​

[/TD]
[TD="width: 151, bgcolor: transparent"]

Issuing Officer<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 122, bgcolor: transparent"]10000100<o></o>
[/TD]
[TD="width: 114, bgcolor: transparent"]10000125<o></o>
[/TD]
[TD="width: 90, bgcolor: transparent"]

Ted<o></o>​

[/TD]
[TD="width: 163, bgcolor: transparent"]10000135<o></o>
[/TD]
[TD="width: 151, bgcolor: transparent"]

Brad<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 122, bgcolor: transparent"]10000126<o></o>
[/TD]
[TD="width: 114, bgcolor: transparent"]10000150<o></o>
[/TD]
[TD="width: 90, bgcolor: transparent"]

Brad<o></o>​

[/TD]
[TD="width: 163, bgcolor: transparent"]10000176<o></o>
[/TD]
[TD="width: 151, bgcolor: transparent"]

Mike<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 122, bgcolor: transparent"]10000151<o></o>
[/TD]
[TD="width: 114, bgcolor: transparent"]10000175<o></o>
[/TD]
[TD="width: 90, bgcolor: transparent"]

John<o></o>​

[/TD]
[TD="width: 163, bgcolor: transparent"]10000110<o></o>
[/TD]
[TD="width: 151, bgcolor: transparent"]

Ted<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 122, bgcolor: transparent"]10000176<o></o>
[/TD]
[TD="width: 114, bgcolor: transparent"]10000200<o></o>
[/TD]
[TD="width: 90, bgcolor: transparent"]

Mike<o></o>​

[/TD]
[TD="width: 163, bgcolor: transparent"]10000125<o></o>
[/TD]
[TD="width: 151, bgcolor: transparent"]

<o></o>​

[/TD]
[/TR]
</tbody>[/TABLE]
<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]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]

Beg. Ticket No.​

[/TD]
[TD]

End Ticket No.​

[/TD]
[TD]

Book Assigned to Officer​

[/TD]
[TD]

Ticket No. Issued​

[/TD]
[TD]

Issuing Officer​

[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]

10000100​

[/TD]
[TD]

10000125​

[/TD]
[TD]

Ted​

[/TD]
[TD]

10000135​

[/TD]
[TD]Brad[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]

10000126​

[/TD]
[TD]

10000150​

[/TD]
[TD]

Brad​

[/TD]
[TD]

10000176​

[/TD]
[TD]Mike[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]

10000151​

[/TD]
[TD]

10000175​

[/TD]
[TD]

John​

[/TD]
[TD]

10000110​

[/TD]
[TD]Ted[/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]

10000176​

[/TD]
[TD]

10000200​

[/TD]
[TD]

Mike​

[/TD]
[TD]

10000125​

[/TD]
[TD]Ted[/TD]
[/TR]
</tbody>[/TABLE]


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.