Auto populate data onto a new sheet based on cell info

[ash2707]

Dear all,

Sorry if I duplicating a thread, but I don't know what words to search for to see if this has been asked.

I have a workbook and on one sheet is all of the data.

What I would like it to do if possible, If I go onto another sheet and input in one cell the location that is then populates the rest of the columns.

Is this possible, do this even make sense?

I can upload a sample document if this board lets me?

 

[Joe4]

Welcome to the Board!

Perhaps a series of VLOOKUP formulas is what you need?
See: https://www.excel-easy.com/examples/vlookup.html

You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.