Connecting a cell value to a formula

[Sphinx9]

Hi, first of all thanks for your time in helping me out.

My problem is probably very simple to you guys, but it has me stumped. All I need is for a cell to populate a row equal to another cell. I think I need something such as =B(A1). So that it will mirror column B row whatever value is in A1. So if the number in A1 was 5 it would fill the cell with =B5.

I hope I've explained it efficiently enough that you can understand what I'm trying to do. If not please let me know and I'll try another way.

I REALLY appreciate the help. I have to have this done by in the morning.

Thanks again,

Sphinx

[ajryan88]

Hi,

Try this formula:

Please Login or Register  to view this content.

Hope this helps

[FDibbins]

Welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[arlu1201]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.