Referencing a Cell to table data

[graeme67890]

Unfortunately I'm not very excel eductated so I'm hoping this is a simple question to solve. I would like to have a cell e.g A1 as a data entry cell. Once the number is entered into the A1 cell (for example 5) I would like to reference the value of A1 (5) to be seached in the table on another worksheet. Once the 5 is found on the other worksheet I would like to have the row beside the 5 in the table to be reproduced on the master worksheet. Does anyone know if they can help me on this? Hopefully I have explained my issue clear enough. Thanks in advance

 

[GlennUK]

Do you mean like in a VLOOKUP function formula?

 

[T. Valko]

Unfortunately I'm not very excel eductated so I'm hoping this is a simple question to solve. I would like to have a cell e.g A1 as a data entry cell. Once the number is entered into the A1 cell (for example 5) I would like to reference the value of A1 (5) to be seached in the table on another worksheet. Once the 5 is found on the other worksheet I would like to have the row beside the 5 in the table to be reproduced on the master worksheet. Does anyone know if they can help me on this? Hopefully I have explained my issue clear enough. Thanks in advance

See if this is what you had in mind:

http://contextures.com/xlFunctions02.html

If you want the entire row returned then you can modify the formula and just copy it across the row where you want the results to appear.

 

[graeme67890]

Thank you very much, you have solved my problem. Have a great day.