| Home |
| Search |
| Today's Posts |
|
#9
|
|||
|
|||
One way would be to incorporate Choose
=CHOOSE(VLOOKUP($D$9,Accounts!A1:G500,7,FALSE),Acc ounts!L4,ACCOUNTS!M4,Accounts!N4,etc...) Obviously you would need to repeat L4 3 times to cover results 1-3 and so on but this will give you a start. Choose will permit up to 29 items in its list. Incidentally, Morrigans assertion that the table must be sorted for VLOOKUP to work is incorrect. Provided you use the 4th argument to Vlookup, FALSE or 0, as you have, then it will work even when the table is not sorted. -- Regards Roger Govier "Phillycheese5" wrote in message news:Phillycheese5.1sue3o_1122491338.1206@excelfor um-nospam.com... I was hoping to get it into 1 cell where it checks for multiple ranges and series of numbers. Thanks. -- Phillycheese5 ------------------------------------------------------------------------ Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196 View this thread: http://www.excelforum.com/showthread...hreadid=390638 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get an IF statement to pull a date range?? | Excel Worksheet Functions | |||
| Match function...random search? | Excel Worksheet Functions | |||
| If statement where the logical test is a range that equals a word | Excel Worksheet Functions | |||
| Return range of values on an "IF" statement | Excel Worksheet Functions | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
Threaded Mode
