| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup:same lookup_value, different returns
I have something like this: =If(A1=VLOOKUP(A1,'SHEET'!A$1:D$100,1,FALSE),VLOOK UP(A1,'SHEET'!A$1:G$100,*3*,FALSE),"") If the condition is true more than once, how can it return the additional corresponding values of column 3? BTW :is it redundant to use the condition and then use a FALSE range lookup? -- javino ------------------------------------------------------------------------ javino's Profile: http://www.excelforum.com/member.php...o&userid=29678 View this thread: http://www.excelforum.com/showthread...hreadid=493983 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting multiple variables returns #VALUE | Excel Discussion (Misc queries) | |||
| C1 appears blank, but ISBLANK(c1) returns false | Excel Worksheet Functions | |||
| Problem with GEOMEAN - returns #NUM error | Excel Worksheet Functions | |||
| When I enter a number in an empty cel, de cel returns the value d. | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
