Get only Vlookup value without filter removal

[karthidhamo]

Hi Everyone.

I have an table with s.no 1 to 100. I get the value from 50 to 60 S. No's from another table by vlookup. Now my question is below..

A) Is it possible without removing filter ( common) and only get the vlookup value?
B) Simply in filter conditions how to be remove my Vlookup value in particular cell reference? Because I can do it only remove the filter. Pls confirm any solution/ ideas.

 

[vletm]

karthidhamo
As with Your previous threads,
please, reread Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

then You'll notice again - what should You do next?

 

[Rickbale]

Hi Everyone.

I have an table with s.no 1 to 100. I get the value from 50 to 60 S. No's from another table by vlookup. Now my question is below..

A) Is it possible without removing filter ( common) and only get the vlookup value?
B) Simply in filter conditions how to be remove my Vlookup value in particular cell reference? Because I can do it only remove the filter. Pls confirm any solution/ ideas.

Try this formula

=INDEX(B4:B19,MATCH(1,IF(SUBTOTAL(3,OFFSET(A4:A19,ROW(A4:A19)-ROW(A4),0,1))>0,IF(A4:A19=F2,1)),0)) into a cell where you want to locate the result, and then press Ctrl + Shift + Enter keys together, and you will get the corresponding value as you need

Hope this helps