Hello,Can anyone help me to list values based on other cells.
I use =IF(MEDIAN(A2,25,40)=A2,A1,"") (if cell is between 25 and 40 ) list A1
I can do this in few lines separately, but would be nice if i can get values i want all in one line.
Thanks you so much
screenshot.6797.jpg
Last edited by Excl3454; 08-08-2021 at 02:24 PM.
Formula:=IF(ISNUMBER(VLOOKUP(A2,{1;7;9},1,0)),A1,"")
Maybe try
=IF(ISNUMBER(MATCH(A2,{1,7,9},)*MATCH(A3,{3,11,22},)*MATCH(A4,{5,10,13},)),A1,"")
Amended formula:=IF(ISNUMBER(VLOOKUP(A2,{1;7;9},1,0)*VLOOKUP(A3,{3;11;22},1,0)*VLOOKUP(A4,{5;10;13},1,0)),A1,"")Originally Posted by josephteh
Thank you so much for your time and quick reply. very nice of you.
i tried but dose not give me all values. here is a screenshot.:
screenshot.6802.jpg
Thank you, this gives me result for A1:J1
IF(ISNUMBER(VLOOKUP(A2,{1;7;9},1,0)),A1,"")
but when combine, I get nothing back with this formula:
=IF(ISNUMBER(VLOOKUP(A2,{1;7;9},1,0)*VLOOKUP(A3,{3;11;22},1,0)*VLOOKUP(A4,{5;10;13},1,0)),A1,"")
and
there is 1, 7, 9 in A2-J2
And
there is 3, 11, 22 in A3-J3
And
there is 5, 10,13 in A4:J4
AND mean all conditions must be All True.
if only one condition need it should be
there is 1, 7, 9 in A2-J2
Or
there is 3, 11, 22 in A3-J3
Or
there is 5, 10,13 in A4:J4
=IF(COUNT(MATCH(A2,{1,7,9},),MATCH(A3,{3,11,22},),MATCH(A4,{5,10,13},)),A1,"")
Many thanks,,,,Very nice of you
Amended formula for OR condition: =IF(ISNUMBER(VLOOKUP(A2,{1;7;9},1,0))+ISNUMBER(VLOOKUP(A3,{3;11;22},1,0))+ISNUMBER(VLOOKUP(A4,{5;10;13},1,0)),A1,"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks