| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Select from List of names to equal a specific rate
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i want to only select one name from a list of the same names | Excel Discussion (Misc queries) | |||
| How do I format list of names formatted last,first to first last? | Excel Worksheet Functions | |||
| Find first occurence in a list that's greater than a specific num | Excel Worksheet Functions | |||
| How select an item in a list box | Excel Worksheet Functions | |||
| Setting up a random list from long list of names ? | Excel Discussion (Misc queries) | |||
Threaded Mode
