Vlookup Help

[SeanFitz90]

Hi All,

Looking for some help with a formula. Attached shows a list of sites with a Ticket type, basically each site will have numerous tickets per site. I am trying to get the created date for that specific site ID to the specific ticket type

Any help would be greatly appreciated

[kev_]

Welcome to the forum
Nothing is attached to your post
To attach a file click on REPLY, then GO ADVANCED, look below for MANAGE ATTACHMENTS etc

ManageAttachments3.jpg

[SeanFitz90]

I have attached

[philaugust2004]

You're going to have to give an example of the answer you are looking for.

[SeanFitz90]

For example site 2000 may have multiple tickets, in fact from checking manually on the database that site has 7 tickets on the system, what I need is to find the created date for the ticket in the attached.

When I do a normal Vlookup from the CSV file with the raw data, I am getting a created date for a different ticket rather than the one in the file.

Hope this helps

[kev_]

Your explanation is not helping....
Please attach your file again, this time showing several results required and exactly which cells should be matched and which looked up to get each result
thanks

[philaugust2004]

If site number, ticket and type can sometimes be identical then no formula will isolate what you want. You need a unique identifier perhaps by joining site number and date?
What does the date refer to in your data? Is that date different to created date?

[SeanFitz90]

Perfect. yes there is a Ticket ID that is unique. Worked a treat. Thanks!!

[philaugust2004]

So it is solved?

[SeanFitz90]

Yes. Thank you

[kev_]

click on Thread Tools at top of thread to mark thread as solved
thanks

[vlady]

FORUM MODERATOR'S REQUEST:

You can mark your thread "Solved"

How?
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Note:
You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given.
By doing so you can add to the reputation(s) of those who helped and shared their time in helping you.

Nice to have you with us.

[kev_]

deleted - posted in error