Calling up relevant data

[e4xit]

Hi,

I would imagine this may have been asked before, but you can never be sure how others worded their posts and the search didnt turn up what I was looking for.

Basically, I have a very simple sheet which has chemicals listed by name (y-axis) and various elements along the x-axis (obv with corresponding amounts in each cell) - For values of zero I have left blank at the moment.

What I would like to be able to do is to find an element (perhaps search box, perhaps something else) then display only the relevant elements which make up this chemical... This is where I am stumbling - I have so many blank cells this becomes quite hard, even with banded rows.

I have limited VBA experience, but always willing to try/learn...

Thanks,

Will

 

[cyrilbrd]

Hi,
would you consider a formula?
if in A1:

	CHCl3	C3H6O	CH2Cl2	Density	 ΔfHo
chloroform	119.38	-	-	1.483	8.8
dichloromethane	-	-	84.93	1.33	6.16
acetone	-	58.08	-	0.791	-250.03

to get this in A6:

	CHCl3	C3H6O	CH2Cl2	Density	 ΔfHo
chloroform	119.38	-	-	1.483	8.8

In A7: a data validation list such as what you mentioned with the range A2:A4.
then in B7:

=IFERROR(INDEX(B2:B4,MATCH($A$7,$A$2:$A$4,0)),"")

Ctrl + Shift + Enter, not just enter.

Although this might not be what you need.
Post a sample of your data if you can with a sample of how you would like the result to look like.
Follow this link.