Forum Discussion
Easy one
I have an easy one for you experts out there. I have sample worksheet attached, the actual has thousands of rows. I would like to be able to enter any number from Sheet 1 column A on Sheet 2 column A...
Here's a solution that uses the relatively new function FILTER. It does require that you have the most recent release of Excel.
You enter the code you wish to search for in cell B1 of Sheet2, and then this formula retrieves the full row corresponding to that code.
=FILTER(Sheet1!A1:F30,Sheet1!A1:A30=Sheet2!B1,"Not found")