Currently, I have a table that will reference and populate Stock Numbers as soon as the associated QR is scanned, however, I have an ENUM column I also need to auto-populate based on the last/most recent scan but Iโm not having any luck whatsoever.
What have you tried?
Iโve tried:
I even created a sheet that is a mirror image of the main table โScanโ google sheet, so I can try to reference but Iโm not getting the result I need.
Youโre using LOOKUP() incorrectly.
This isnโt doing what you think it is. Read more:
This may help too.
User | Count |
---|---|
41 | |
27 | |
27 | |
20 | |
13 |