VLOOKUP help??

[orsm6]

hi all,

I am hoping this is possible but need some more experienced help.

I hope this makes sense. I am trying to find out if there is a way (using formulas) to look for any value greater than 100 in column N and put the numbers into column BB

in column N almost every second line has a number over 100. another problem I have is that there can often be the same number twice, but I still want both numbers to show up in column BB.

the whole point to this is to not have blank lines between numbers in Column BB.

hope that makes sense, and hope it is possible, thanks for any help!!

 

[Anthony47]

Try in BB2:

=IFERROR(INDEX(N$1:N$1000,SMALL(IF(N$1:N$1000>100,ROW(N$1:N$1000),""),ROW(A1))),"")

To be confirmed using Contr-Shift-Enter, not Enter only.

Then copy downward

Bye

 

[orsm6]

this works great.

how can I apply this to capture a time value next to the number greater than 100?

 

[orsm6]

ignore that, I worked out a solution

 

[Anthony47]

You mean getting both the values in column N and in column O?

This in BB2

=IFERROR(INDEX(N$1:N$1000,SMALL(IF($N$1:$N$1000>100,ROW(N$1:N$1000),""),ROW(A1))),"")

Confirm by Contr-Shift-Enter; then copy to BC2; then copy downward

Bye

Edit:

ignore that, I worked out a solution

Then ignore my answer