Needing help with "IF" function please.

[Jsweeten]

Hey guys,

Thanks for taking the time to read and help out with this problem I been having
I've created multiple spreadsheets and databases but I am having some serious trouble with this one

I have two work sheets

First sheet are materials such as metals, liquid, and etc. It list the velocity at which sound travels through a particular material.
Second sheet are calculations.

Pretty much what I want to do is something like `=IF(D34=Materials.A3:A49,Materials.B3:B49)
This obviously doesn't work

What I want to do is be able to type in the material into a cell and have the velocity inputted into the cell below it

I've done long nest of If statements and it seems I can't add more into the one cell
So I figured I'd come to the pros

Any help will do

Thanks
JoshUntitled.jpgUntitled1.jpg

[martindwilson]

you have
Libre Office
you should post here
http://www.excelforum.com/for-other-...mobile-os-etc/

[Jsweeten]

I understand what program I am using
In fact I have multiple excel programs
including Microsoft

What I am asking for is help with a code

[FDibbins]

I think Martin was suggesting that that link might be a better place to go and ask for the help you want. I am sure he knows that you are perfectly aware of what program you are using.

Having said that, have you tried to put the info into a 2-columnb table some where and then use a vlookup to return the velocity you want?

[martindwilson]

libre office is not excel and solutions posted for excel may not work..the delimiters are different,arrays don't transfer across properly,the same applies to open office and google docs.in this case as fdibbins said a vlookup will probably work fine

[dredwolf]

you could probably do an Index(match to get the result--something like:
=Index(Materials!$A$3:$G$49,Match($D$34,Materials!$A$3:$A$49,0),2)

not sure of the syntax in Libre, so that may have to be adjusted,and I'm not sure of the ranges ,as it is very hard to see on the screen shot