So essentially i have two workbooks.
One looks something like this:
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
And the other is very similar bar a few extra columns.
I need to be able to pull the ticket number from the other worksheet for the said users.
How can i lookup the username but pull back the ticket number for that user?
If it makes it easier the columns in the sheet i need the data are:
Username (A1) Ticket Number (The missing information) (H1) i can then extend this down.
And the other sheet where i pull the information is:
Username (W) Ticket Number (this has the info i need) (AC)
Can anyone explain how to do this?
One looks something like this:
Username | First name | Last name | Ticket number |
User1 | Jim | Bob | |
User2 | Bob | Jimmy |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
And the other is very similar bar a few extra columns.
I need to be able to pull the ticket number from the other worksheet for the said users.
How can i lookup the username but pull back the ticket number for that user?
If it makes it easier the columns in the sheet i need the data are:
Username (A1) Ticket Number (The missing information) (H1) i can then extend this down.
And the other sheet where i pull the information is:
Username (W) Ticket Number (this has the info i need) (AC)
Can anyone explain how to do this?