Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I return Multiple values using VLookup?
Hey,
I have a spreadsheet running while using VLookup, now in the first row I have multiple dollar values but different account names that relate to the dollar value is there anyway to return the other account names that have the same dollar value? The function looks like ; =VLOOKUP(A1,'01.06.07'!$A$1:$C$2000,2,FALSE) and the multiples would be like I need to return column 1 and 4, so I have the multiples. 29.8 1942978 - ACCUFIT 1942978 NETBANK TFR 29.8 1109582 - ACCOUNT 1109582 DIACORE PTY LT Can anyone help with this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I return Multiple values using VLookup?
To return the corresponding values for the second column, Column B, try
the following... B1: =COUNTIF('01.06.07'!A1:A2000,A1) C1, copied down: =IF(ROWS(C$1:C1)<=$B$1,INDEX('01.06.07'!$A$1:$C$20 00,SMALL(IF('01.06.07'! $A$1:$A$2000=$A$1,ROW('01.06.07'!$A$1:$A$2000)-ROW('01.06.07'!$A$1)+1),RO WS(C$1:C1)),2),"") ....confirmed with CONTROL+SHIFT+ENTER. To return the corresponding values for the 3rd column, change the 2 at the end of the formula to a 3. Hope this helps! In article , Sean wrote: Hey, I have a spreadsheet running while using VLookup, now in the first row I have multiple dollar values but different account names that relate to the dollar value is there anyway to return the other account names that have the same dollar value? The function looks like ; =VLOOKUP(A1,'01.06.07'!$A$1:$C$2000,2,FALSE) and the multiples would be like I need to return column 1 and 4, so I have the multiples. 29.8 1942978 - ACCUFIT 1942978 NETBANK TFR 29.8 1109582 - ACCOUNT 1109582 DIACORE PTY LT Can anyone help with this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup one value and return multiple values | Excel Discussion (Misc queries) | |||
Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
How can I use the vlookup function to return a sum of the values? | Excel Discussion (Misc queries) | |||
vlookup function return all values | Excel Worksheet Functions | |||
Search multiple values to return single values | Excel Worksheet Functions |