IF formula required ( i think) one cell equals another cell, then give value of another.

[Smedlex]

Hello!

I am trying to work out a formula for the following:

I have data D10 through G10.

In cell M10 I want to compare to the data in B10 to cells D10 through G10.

If it matches one of the cells then I would like the data that sits the row below another 2 rows of data to be displayed - I11 thru T11 and I15 thru T15 ( are the upper rows )
I12 thru T12 and I16 thru T16 ( are the lower rows, who's data I ultimately want displayed in M10)...

I hope that makes sense to someone who can help!

[:) Sixthsense :)]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[FDibbins]

Perhaps INDEX/MATCH?

[Smedlex]

Ok, thanks for your help so far but I'm thinking I might change my data input to help with this formula.

So now, this shouldn't be too difficult.

Basically I want to compare the number in b10 to the number in e10 if they're the same, display the number from c10 in cell m10. That's it really!

Thanks in advance!

[:) Sixthsense :)]

May be...


In M10 Cell


=IF(B10=E10,C10,"")

[Smedlex]

Thanks for your help everyone!.

solved!