VLOOKUP bottom to top

[Paul Naylor]

Hi , hoping someone can help

I have a data set 3 columns ( work sheet names "Agent Lates" :

Column A - Times
Column B - Agent Names
Column C - Agent States (various but I'm only interested In... Logged In, Available( 1st instance) & Logged Out )

I'm wanting to display the given times for agents for the above 3 states on a separate worksheet ( Agent States) that has a list of all agents column A (3-20) , with 3 seperste headings column's B2,C2& D2 for 3 ststes ( logged in, available and logged out.

To achieve this I've had to create a helper column on the data sheet in a spare column to combine agent name & agent state (e.g. =B2&" "&C2 ) and another column to replicate the times from column a , so that I can then do a multiple vlookup to display the relevant data

=VLOOKUP($A3&" "&$B2,'Agent Lates'!$D$2:$E$3000,2,False)

The only problem is that the original data source the times are in latest not earliest , so I am having to sort the data first before copy & pasting into the "Agent Lates" workbook, think I need to use something other than VLOOKUP to achieve , but not sure what? Hoping someone can help me ?

 

[awoohaw]

You mention many different versions of excel on your button. But, which are you using for this workbook?
In 365 you can lookup from the bottom of the columns in XLOOKKUP.

Also, some sample data would be a help. The xl2bb add in (link below) is very good for that. If you cannot use it then please post a table, not an image.