Forum Discussion
Solved
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 barc...
Hi Saeed,
Based on your requirement I have modified the file, hopefully it will fulfill your need now.
Thanks,
Tauqeer
You are most welcome.
In case number of rows are more than 5,400 then you just need to edit the range in the formula. For example if you have 7,000 rows then your new formula will be :
IF([@[Product Barcode]]="","",(IFERROR(VLOOKUP([@[Product Barcode]],list!$B$4:$C$7000,2,0),IFERROR(VLOOKUP([@[Product Barcode]],list!$D$4:$E$7000,2,0),IFERROR(VLOOKUP([@[Product Barcode]],list!$F$4:$G$7000,2,0),"")))))"
I think due to some extra formatting your file is slow. I will try to simplify it and update you accordingly. Three vlookup() in a same formula will not consume more memory.
Thanks
Tauqeer
In case number of rows are more than 5,400 then you just need to edit the range in the formula. For example if you have 7,000 rows then your new formula will be :
IF([@[Product Barcode]]="","",(IFERROR(VLOOKUP([@[Product Barcode]],list!$B$4:$C$7000,2,0),IFERROR(VLOOKUP([@[Product Barcode]],list!$D$4:$E$7000,2,0),IFERROR(VLOOKUP([@[Product Barcode]],list!$F$4:$G$7000,2,0),"")))))"
I think due to some extra formatting your file is slow. I will try to simplify it and update you accordingly. Three vlookup() in a same formula will not consume more memory.
Thanks
Tauqeer
Hi tauqeeracma
these are the final file
if you can check to find a faster way to work with me it will be helpful
I will use the tablet for counting the product in the store
then I will copy the data and paste it in the second file to find the difference and make the inventory report
thanks for all the help you give and I wish all the best for you
my regards
Saeed