diplaying multiple values from a table

[jac_perdue]

Hello this is my first time posting here so if this is not where to to post this i apologize in advance. i have not had to use excel in a while and it seams that i have missed placed a lot of the knowledge that i use to have in it.

what my problem is, is that i need to look up values in a table then display all the values that are associated with that. i have included a copy of my excel sheet.

my table seen below has no data where there does not need to be data. and data where i need to see it. the data that is displayed is part of what i need to display along with the description and part number that make up the header of that column. ideally i need to have a operator enter the look up criteria on say sheet1 then have the data display on sheet 1 while the actual data stays on sheet 2.

Table.jpg



i know this is a basic way to say what i want to do. and that what i want to do is probably harder than i think it is going to be. any guidance would be appreciated.

thanks in advance for the help figuring this out.


Base look up chart.xlsx

[BB1972]

jac_perdue,

Welcome to the forum. Can you make a few changes to your xlsx file, and upload it again, indicating what sheet is/contains data (you say above "....the actual data stays on sheet 2." but I only see a list of part numbers there; and indicating clearly what your expected results should be when you enter your search criteria. When this is done, we should be able to assist you.