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 |
---|---|
36 | |
32 | |
30 | |
18 | |
16 |