ExcelBanter - Using the IF formula to print from another worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Using the IF formula to print from another worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/219722-using-if-formula-print-another-worksheet.html)

Ian

Using the IF formula to print from another worksheet

Is there a way of using the IF formula to print what is in another cell on a
second worksheet if the answer to the query is correct on the first worksheet
cell.
ie- in B3 asking if in A2 is =1 print out whats in B3 on Sheet 2.

All times are GMT +1. The time now is 06:03 PM.