LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default I need a Formula for a Database

Here is what i need.

I have a list of of one hundred (or More) 4 digit tracking codes that have a
label (description) for each; for example 0234 is Hauling, 0142 is General
Labor etc. I think what i want is a Database so when i input my 4 digit
tracking code into cell 'A1', cell 'B1' will fill in the correct description
and i won't have to type it anymore.

I am guessing that i create a 'worksheet1' that has all the 4 digit tracking
codes in Column 'A' and all their descriptions in Column 'B'

On 'worksheet2' i would need a formula in the cells for Column 'B' that
basically says (i think) - If 'Worksheet1' cell in column 'A' equals the
tracking code entered in 'Worksheet2' cell 'A1' then insert 'worksheet1's
appropriate Column 'B' description into 'Worksheet1' cell 'B1'.

Please Help me!!!
--
Jon Robershaw
Wardell Builders, Inc
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula for database search - is it possible? sos-DC[_2_] Excel Discussion (Misc queries) 7 July 11th 08 08:14 PM
database query not showing foxpro database How I import data mangat New Users to Excel 1 June 24th 07 03:31 PM
Help with database formula. Bazza Excel Worksheet Functions 1 November 15th 06 10:04 AM
Database Formula Ross Excel Discussion (Misc queries) 4 September 10th 06 11:30 PM
DATABASE FORMULA becky Excel Discussion (Misc queries) 1 January 20th 05 01:45 AM


All times are GMT +1. The time now is 02:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"