Consider using VLOOKUP().

Have a Q/A table somewhere in the spreadsheet and when the FAQ is selected
in E5 the answer will appear in F7
--
Gary''s Student - gsnu200857


"gwtechie72" wrote:

I am trying to create a FAQ in Excel 2003, I have the list of questions, but
I am not able to have the answers show up in a different cell. For example:
if the Questions are in cell E5, I want the answers to show up automatically
in F7. Can anyone help me with this?