Ecxel "lookup" problem

Hi all,
I have a table similar to this:

1 2 3
2 3 4
3 5 7​

I need to test for a result in row 3 based on data entered elsewhere in the spreadsheet. If there is not match in row 3 I wish to display the text "No Match" in another cell.
I hope this is clear.
Cheers and TIA,
Graeme.

 

An IF statement in the cell you wish to change will do that. For example, you put this in cell A1 on sheet1:

Code:

=IF(Sheet2!A1=C1, "Hello ", "Boo ")

The bit Sheet2!A1=C1 basically means content of cell A1 on Sheet "Sheet2" is the same as the content of cell C1 on this sheet. The structure of the IF statement is:
=IF(condition, if condition returns true output this, else output this)

So in the example, if the content of C1 is the same as cell A1 on sheet 2, the output will be "Hello" in the cells that contains the if statement. If the C1 and A1 are different "Boo" will be output.

You could also use conditional formatting to change the colour or format of a cell depending on where Sheet2!A1=C1 is true.