Thanks for help
Thanks for help
Last edited by adsako; 01-29-2020 at 03:12 AM.
Hi,
The formula might be right, however there are additional spaces in Column D after Non, similarly in different columns aswell.. Get rid of those and it should work
Cheers!
Deep Dave
Put this in Cell F7
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.=IFERROR(INDEX(Table1[[Nom ]],SMALL(IF((Table1[Journée de la sappe]=$G$3)*(Table1[Interessé ? ]=$G$4)*(Table1[Contrat signé ? ]=$G$5)*(ROW(Table1[Journée de la sappe])-ROW(Table1[[#Headers],[Journée de la sappe]]))=0,"",(Table1[Journée de la sappe]=$G$3)*(Table1[Interessé ? ]=$G$4)*(Table1[Contrat signé ? ]=$G$5)*(ROW(Table1[Journée de la sappe])-ROW(Table1[[#Headers],[Journée de la sappe]]))),ROWS($F$7:F7))),"")
Hi
Ive tried ... unfortunately still shows error
Hi,
Can you tell me what the expected output should look like?
Hi
what I would like to see is:
- in column G list of the suppliers (pulled out from column A) who meet criteria mentioned in cell G3 and G4 and G5.
as the result for instance:
in case in cell G3 / G4 / G5 we got "non" / "non" / "non respectively my list shouldinclude only two suppliers mentioned in cell A11 and A39
or as a second example --- in case there are "reduction" / "oui" / "non" in cell G3 / G4 / G5 respectively I should get a list of suppliers (from column A) listed in cell A8 / A18 / A19 (because this cells meet criteria)
I do not want column G to be dependent on column F and list of suppliers listed there - this column/list was created to return list of the suppliers based on criteria in cell G3
When I apply suggested formulas I get ERROR in return
basically I do not know how to introduce MORE THAN ONE criteria into my lookup
Hope this explanation helps
thanks
Hi,
Please see the file attached
Formula used -
Commit using Ctrl+Shift+Enter=IFERROR(INDEX(Table1[[Nom ]],SMALL(IF(($G$3=Table1[Journée de la sappe])*($G$4=Table1[Interessé ? ])*($G$5=Table1[Contrat signé ? ])*(ROW(Table1[[Nom ]])-ROW(Table1[[#Headers],[Nom ]]))=0,"",($G$3=Table1[Journée de la sappe])*($G$4=Table1[Interessé ? ])*($G$5=Table1[Contrat signé ? ])*(ROW(Table1[[Nom ]])-ROW(Table1[[#Headers],[Nom ]]))),ROWS($G$7:G7)-ROWS($G$7)+1)),"")
Last edited by NeedForExcel; 01-28-2020 at 05:06 AM.
Hi
that works perfectly
thank you
I'm trying to understand now logic behind
would LOOKUP formula work here? and how it might be used?
thanks
Hi,would LOOKUP formula work here? and how it might be used?
Vlookup cannot be used for this problem.. The usage of Vlookup is quite different from the requirement here..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks