Output 1 row

[mn1t]

Hello - Here's 1 for everyone . . .

I have a sheet with item numbers and their associated barcodes. If I do a simple 'Ctrl-F', I can find the correct one but using the scanner to try to scan the correct barcode from a laptop screen full of barcodes is proving difficult.

So here's what I'm thinking:

In Sheet2, we have a cell where the input goes. Say we type '8001' and hit enter. then below that cell, the output of that 1 whole row from Sheet1 appears for quick and easy scanning. Also, duplicates are removed from Sheet1.

Thanks for your help on this or other suggestions ! ! !

mn

 

[The_Macrotect]

Hi mn,

Wow, I overthought this for a very long time lol.

Is this what you're looking for?

Excel 2007 32 bit

	A	B
1	Item Number:	4988
2
3	Format This Cell for Barcode and enter the following formula: =B1 <tbody> </tbody>

<tbody>
</tbody>

Let me know if you're looking for something different.

All the best,
Matt