Excel Formula Complex

[kmelancon86]

I am looking for a way to write a formula that can do the following.

I am doing torque values, and I created a table on one sheet that I will refer to as "torque Values"

What I am trying to do is:

If J9 >= 300, then take the value in O9, go to "torque values" find that value in column A, then paste the value in column b of "torque value" (that is next to the value found in column A)

I have no idea where to even start on this. any help would be great.

 

[dreid1011]

Could you post a sample of your data and expected results?

 

[kmelancon86]

I am not sure how to post an image on here. I have cropped the pages down from print screen to show only the columns in question. I can email it to you if you would like. My email is kmelancon86@gmail.com.

 

[dreid1011]

You can save some screen prints and upload them to a site like imgur.com, then post the links here. Or you can upload the file to dropbox.

 

[RonB1111]

This formula assumes your torque values and cells J9 and O9 are all in the same worksheet:
=IF(J9>=300,VLOOKUP(O9,A:B,2,FALSE),"")

 

[kmelancon86]

Imgur

 

[dreid1011]

Give this a try:

=IF($B2='Torque Sheet'!$B$1,INDEX('Torque Sheet'!$B$3:$B$15,MATCH($C2,'Torque Sheet'!$A$3:$A$15,0)),INDEX('Torque Sheet'!$E$3:$E$15,MATCH($C2,'Torque Sheet'!$A$3:$A$15,0)))

 

[kmelancon86]

That formula was perfect. Is ended up
=IF([@RATING]=150,VLOOKUP([@[Bolt Size]],'Torque sheet'!A:B,2,FALSE),VLOOKUP([@[Bolt Size]],'Torque sheet'!A:E,5,))

Thank you so much for the help. I have never used a VLOOKUP, but seeing how easily that made things...I think I should start.

 

[kmelancon86]

Thanks for the reply dreid. I think I am going to stick with the VLOOKUP on this one, but I am going to save that formula you just posted for later comparison in making future formulas.