Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup display
I have a list of sales invoices in column B with a associated sales territory
in column A. Can vlookup display more than one invoice #. If so, how? Mark |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup display
On Mon, 15 May 2006 14:18:01 -0700, Mark
wrote: I have a list of sales invoices in column B with a associated sales territory in column A. Can vlookup display more than one invoice #. If so, how? Mark No. You probably need to filter the data - either in place or copy somewhere else. HTH RB __ |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup display
Hi,
Assuming your data is arranged in range A1:B7 like this Ashish 100 Sanjay 200 Pongal 300 Ashish 400 Rajesh 500 Suresh 600 Ashish 700 In cell A10 enter any of the names mentioned in range A1:A7. In cell B10, enter the following array formula (Ctrl+Shift+Enter) =IF(ISERROR(INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$ 10,ROW($A$1:$A$7)),ROW(1:1)),2)),"",INDEX($A$1:$B$ 7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1 )),2)) Copy this formula down. Please let me know if you need any more clarifications on this ). Will be more then willing to help you Regards, Ashish Mathur "Mark" wrote: I have a list of sales invoices in column B with a associated sales territory in column A. Can vlookup display more than one invoice #. If so, how? Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
Display rows of data - vlookup? | Excel Worksheet Functions | |||
VLOOKUP works sometimes | Excel Worksheet Functions | |||
Multiple Vlookup? | Excel Worksheet Functions | |||
vlookup. | Excel Worksheet Functions |