Excel formula that would plug in numbers from another table based on info given

[esrica2]

Hello all,
I wanted to know if there was a way that I can have data from one cell placed in another cell based on the data put in. Meaning I have a guide of numbers. I use that guide to make tic tac toe boxes. I want to be able to put the number 3 in one cell and have the numbers 1 and 5 show up in the columns beside it. So it would look like 3 1 5 after putting in the 3. Or whatever number I put in the corresponding number appears in the second two cells. Is that possible? I tried to used the IF function and the IF function with conditions and nothing is working. Can anyone help me please.

[JohnTopley]

Please post a sample file with examples of expected output.

click "Go advanced" then "Paper Clip" icon to upload file.

[bebo021999]

With A1 is first number (3),

B1=IF(A1="","",1)

C1=IF(A1="","",5)

I wonder if B1 and C1 is constant or not?

[esrica2]

I actually figured it out using another thread. But thanks anyway. I had to end up doing something different which ended up being what I was actually trying to do in the first place.