Forum Discussion
return the data from another table
Hi
I'm trying to get the data from the table in the next sheet
so when I make counting for the inventory I make sure that it,s the correct item
I just need when I reed the barcode with the barcode reader the UOM get the data from the list table there are 3 barcodes columns and next to each one of them the uint
so how to make a formula that gets data when it found the number get the data from the next cell on the right side
Hi Saeed,
Based on your requirement I have modified the file, hopefully it will fulfill your need now.
Thanks,
Tauqeer
8 Replies
Hi please see if you can help me I need to take the data
if the barcode was in column barcode 3 then get the UOM from the unit 3 column same row if need more explain well do
sorry for my bad English
I know I can count on you
Hi Saeed
Please see the attached file, hope it will help you.
Thanks
Hi tauqeeracma thank you for your help
this can't work because it works with only 1 column
I have 3 columns of barcodes and eath one of them have his special Unit in a separate column
so when I take a read of barcode I want it to know from which column and then return the unit next to that column
column 1 / column 2 / column 3 / column 4 / column 5 / column 6
row 1 barcode 3 / unit3 / barcode 2 / unit 2 / barcode 1 / uint1
row 2 63555262 / Psc / 63555263 / dozen / 63555264 / carton
so if I take a read and if it was 63555262 then it returns in the UOM column in the stock count sheet
Psc and if I reed the 62555263 then return dozen and so on
I hope that I clear what I need and I thank you all in advance
my regards
