Re: [ExcelVBA] Ho to filter both columns and rows

 

Hi Paul
 
Thanks a lot for the reply ..got the solution using
=INDEX($B$2:$D$4,MATCH(B8,$A$2:$A$4,0),MATCH(A8,$B$1:$D$1,0))
 
-Vimal

From: Paul Vermeulen <paul.vermeulen@vulcantech.com.au>
To: ExcelVBA@yahoogroups.com
Sent: Tuesday, 14 February 2012 8:56 AM
Subject: RE: [ExcelVBA] Ho to filter both columns and rows

 
Vimal, research "match". It gives the intersect, and then you display
the value of the matching reference.

From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On
Behalf Of Vimal
Sent: Tuesday, 14 February 2012 9:18 AM
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] Ho to filter both columns and rows

Hi
Pls help me providing the formula or macro for the below requirement
ex:
A B C
X 1 4 7
Y 2 5 8
Z 3 6 9

1) When the user selects 'A' and 'X' the output should be 1
2) Output should display in another cell

The user will not be able to see the table he just enters 'B' and 'Z'
and output should display automatically in new cell '6'

Thanks in Advance!
Vimal

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (3)

Recent Activity:

• New Members 5

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___