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
Item Number:

<tbody>
[TD="align: center"]1[/TD]

[TD="align: right"]4988[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]
3[/TD]
[TD="align: center"][TABLE="width: 246"]
<tbody>[TR]
[TD="class: xl65, width: 246"]Format This Cell for Barcode and enter the following formula:

=B1[/TD]

</tbody>

[/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]


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

All the best,
Matt