DGET help please - Boolean formula needed ?

E

eggshall

New Member
Joined
Jul 1, 2014
Messages
1
Hi... I have found this site very helpful, so I signed up.

I just need help to get my data table to respond with the correct CODE for the relevant BARCODE in my sheet.
But it only does it if the BARCODE is scanned in the same line as the table ?
That doesn't help me. When I scan a barcode , I need the adjacent cell to display the CODE for that barcode no matter where it is scanned in clolumn E. I hope I am making sense. Please assist.
59882

http://upurs.us/view/59882

Thanks
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
You must log in or register to reply here.

Similar threads

A
  • Question Question
Help with scanning barcodes into an excel invoice
2
Replies
12
Views
1K
RoryA
RoryA
A
  • Solved
Pivot Table Sum giving Zeros but count works
Replies
5
Views
1K
RoryA
RoryA
C
  • Question Question
Pull First Text Value in a Column
Replies
6
Views
578
CrushFabrication
C
I
  • Question Question
Help with VBA script please
Replies
3
Views
392
jolivanes
jolivanes
C
  • Solved
Extracting data with VBA macro button from files in designated folder
2 3
Replies
20
Views
716
Micron
M

Forum statistics

Threads
1,223,277
Messages
6,171,156
Members
452,385
Latest member
Dottj

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top