Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-10-2012, 09:51 AM
Spanec Spanec is offline IF Check Field and return content (Small DB-table) Windows XP IF Check Field and return content (Small DB-table) Office 2003
Novice
IF Check Field and return content (Small DB-table)
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
IF Check Field and return content (Small DB-table) small caps auto check gene Word 1 12-03-2011 03:04 PM
IF Check Field and return content (Small DB-table) Table of content problem csharper Word 1 10-02-2011 10:19 AM
IF Check Field and return content (Small DB-table) HTML Content in Mail Merge Field Ilmater Mail Merge 1 09-04-2011 02:47 AM
Table of Content Eat up RAM Resources Tommy Word 0 08-23-2010 10:08 PM
How to use the content of a combobox for {IF} field? Melaanie Word 0 06-14-2010 02:00 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft