trying to create what if formulas with text

[freeman_edwardson]

want worksheet 1 cell a1 to reference off worksheet 2 cell a1, take what is in worksheet 2 cell b1 and put it in worksheet 1 cell b2.

any ideas would be helpful.

many thanks

freeman

[#2]

@freeman_edwardson 

You can use the IF function in Excel to create a formula that references cells in another worksheet. Here's an example formula that you can use in cell B2 of Worksheet 1:

=IF(Sheet2!A1="some text", Sheet2!B1, "")

This formula checks if the value in cell A1 of Worksheet 2 is equal to "some text". If it is, the formula returns the value in cell B1 of Worksheet 2 and puts it in cell B2 of Worksheet 1. If it's not equal to "some text", the formula returns an empty string.

Hope it helps you!

[#3]

@NikolinoDE thanks mate, what if i have multiple cell values like a table full of say 10 and i want the formula to identify which value it is in the list and then return the accompanying value back over into first worksheet.

example

worksheet 1 cell 1a shows 498, cell 1b searches through worksheet 2 cells 1a to 10a and finds 498 in cell 4a and corresponding cell 4b has value to show up in worksheet 1 cell 1b