Thread: [Solved] IF Check Field and return content (Small DB-table)
View Single Post
 
Old 01-10-2012, 09:51 AM
Spanec Spanec is offline Windows XP Office 2003
Novice
  
Join Date: Jan 2012
Posts: 7
Spanec is on a distinguished road
Smile IF Check Field and return content (Small DB-table)
I have a IF issue . I Have a Data Table in Sheet1 with Code and Description data(Text and Numbers) . I want to make a Sheet2 that will accept data grom QR Reader at column Code, check for that data in the DB table (Sheet1) and return data from the next Column in the row where the data was found.


Sheet1
Code Description
bla blablabla
.
.

Sheet2:
Code Description
Read from the QR Scaner If Code (Sheet2)=any Code(Sheet1), return Description from Sheet1

If Code=bla (Read with BarCode Reader) than Description=blablabla (auto filed from Sheet1Description)
Last edited by Spanec; 01-10-2012 at 02:15 PM. Reason: More clear
Reply With Quote