Hi Shirley

No your lookup table does not have to be sorted.
As Biff said, use the 4th argument in Vlookup of False or 0 to deal with
tables in an unsorted order

=Total_Hours*VLOOKUP(A1,Sheet2!A1:B3,2,0)

or exactly the same meaning
=Total_Hours*VLOOKUP(A1,Sheet2!A1:B3,2,FALSE)

Regards

Roger Govier


Shirley wrote:
As I have been reading, to use a lookup table I need to sort in ascending
order? I guess that can be on another worksheet? Thanks, I'll keep messing
with it. Yes, I am trying to calculate a billable rate. I have created a
custom Business Works report to Excel & just need a few more fixes to insert
info I'd like to show.