I have a spreadsheet with data on it. I was wondering if there would be any sort of way to have like a search box on a blank sheet which searches already entered data (in this case, Reg. numbers). Data I have entered would be from cell B2 to V2, B3, to V3 and so on. When the reg. number is found, would it be possible to display all of the info relating to it from that row? Sorry if this doesn't make sense.
Excel - Help
- Thread starter buckeejit
- Start date
You could use a VLOOKUP formula in each cell for every column you wanted data returned for and have it check the cell you type the Reg in to find the corresponding row of data on the other sheet.
http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx
http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx