Forum Discussion
trying to create what if formulas with text
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
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!
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
