I have a spreadsheet that has something similar to thefollowing:<o
></o
>
[TABLE="class: MsoTableGrid"]
<tbody>[TR]
[TD="colspan: 3"]
[/TD]
[TD="width: 163, bgcolor: transparent"]
[/TD]
[TD="width: 151, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 122, bgcolor: transparent"]
[/TD]
[TD="width: 114, bgcolor: transparent"]
[/TD]
[TD="width: 90, bgcolor: transparent"]
[/TD]
[TD="width: 163, bgcolor: transparent"]
[/TD]
[TD="width: 151, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 122, bgcolor: transparent"]
[/TD]
[TD="width: 114, bgcolor: transparent"]
[/TD]
[TD="width: 90, bgcolor: transparent"]
[/TD]
[TD="width: 163, bgcolor: transparent"]
[/TD]
[TD="width: 151, bgcolor: transparent"]
[/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"]
[TD="width: 163, bgcolor: transparent"]10000135<o
></o
>
[/TD]
[TD="width: 151, bgcolor: transparent"]
[/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"]
[TD="width: 163, bgcolor: transparent"]10000176<o
></o
>
[/TD]
[TD="width: 151, bgcolor: transparent"]
[/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"]
[TD="width: 163, bgcolor: transparent"]10000110<o
></o
>
[/TD]
[TD="width: 151, bgcolor: transparent"]
[/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"]
[TD="width: 163, bgcolor: transparent"]10000125<o
></o
>
[/TD]
[TD="width: 151, bgcolor: transparent"]
[/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
>


[TABLE="class: MsoTableGrid"]
<tbody>[TR]
[TD="colspan: 3"]
<o
></o
>


[TD="width: 163, bgcolor: transparent"]
Find this number in range A1:B4<o
></o
>


[TD="width: 151, bgcolor: transparent"]
Bring back Officer who issued Ticket
(ticket assigned to)<o
></o
>
(ticket assigned to)<o


[/TR]
[TR]
[TD="width: 122, bgcolor: transparent"]
A<o
></o
>


[TD="width: 114, bgcolor: transparent"]
B<o
></o
>


[TD="width: 90, bgcolor: transparent"]
C<o
></o
>


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


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


[/TR]
[TR]
[TD="width: 122, bgcolor: transparent"]
Beg. Ticket No.<o
></o
>


[TD="width: 114, bgcolor: transparent"]
End Ticket No.<o
></o
>


[TD="width: 90, bgcolor: transparent"]
Book Assigned to Officer<o
></o
>


[TD="width: 163, bgcolor: transparent"]
Ticket No. Issued<o
></o
>


[TD="width: 151, bgcolor: transparent"]
Issuing Officer<o
></o
>


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


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


[/TD]
[TD="width: 90, bgcolor: transparent"]
Ted<o
></o
>
[/TD]

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


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

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


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


[/TD]
[TD="width: 90, bgcolor: transparent"]
Brad<o
></o
>
[/TD]

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


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

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


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


[/TD]
[TD="width: 90, bgcolor: transparent"]
John<o
></o
>
[/TD]

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


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

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


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


[/TD]
[TD="width: 90, bgcolor: transparent"]
Mike<o
></o
>
[/TD]

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


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

[/TR]
</tbody>[/TABLE]
<o


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

