1.

Solve : Need help finding an Excel function/formula?

Answer»

I need to place a FORMULA in an Excel spreadsheet that does the following:

If Sheet 1, CELL A2=Alpha, place A3 in B1 of Sheet 2.

I hope that's CLEAR. If it isn't, let me know. Thanks! Just tested in Excel 2007.... ALSO works in Excel 5 so probably works with every version:

=IF(Sheet1!$A$2="Alpha",Sheet1!$A$3,"")Thanks! I had to tweak it a little bit, but I would have been here all night without your help! Quote from: JesinFL on March 04, 2010, 05:48:54 PM

Thanks! I had to tweak it a little bit, but I would have been here all night without your help!

Your welcome Why did you write 'your'? =P


Discussion

No Comment Found

Related InterviewSolutions