What I'm trying to do is on cell B3 on sheet1 when I enter any RFQ number that it will populate the part number, rev , Description, etc... on sheet1 from the data tab. Everything from the data tab that's associated with the RFQ number will be populated in sheet1.
The column headers are the same for ease of simplicity. On the attachment I have in cell B3 as 4000 as my example.
The intent is auto populate those cells since I will hundreds of RFQ numbers with data.