{"id":481,"date":"2008-06-21T02:32:52","date_gmt":"2008-06-21T07:32:52","guid":{"rendered":"http:\/\/alsplace.aldenbaker.com\/alsplace\/microsoft\/ms-office\/ms-excel\/481\/use-excel%e2%80%99s-lookup-functions-to-search-a-database\/"},"modified":"2008-06-21T02:32:52","modified_gmt":"2008-06-21T07:32:52","slug":"use-excel%e2%80%99s-lookup-functions-to-search-a-database","status":"publish","type":"post","link":"https:\/\/alsplace.info\/?p=481","title":{"rendered":"Use Excel\u2019s Lookup functions to search a database"},"content":{"rendered":"\n\n

Date<\/strong>: June 16th, 2008<\/p>\n

Author<\/strong>: Mary Ann Richardson<\/p>\n

<\/p>\n

You can use Excel’s Lookup functions to build a worksheet that can be used to search a database table. For example, say you’ve imported the following table from your Access database to Sheet2 of your Excel workbook:<\/p>\n

<\/p>\n

To build a worksheet that can be used to look up an intern’s pay rate by entering the intern’s ID, follow these steps:<\/p>\n

\n
    \n
  1. Open the workbook, click the Sheet2 tab, and select the range A2:H5.<\/li>\n
  2. Click in the Name box, type Interndata<\/em>, and then press [Enter].<\/li>\n
  3. Click on the Sheet1 tab.<\/li>\n
  4. Click cell D6 and enter Employee ID<\/em>.<\/li>\n
  5. Click cell D8 and enter Name<\/em>.<\/li>\n
  6. Click cell E8 and enter the following function:<\/li>\n<\/ol><\/div>\n
    \n

    =VLOOKUP(E6,Interndata,3,FALSE)&" "&VLOOKUP(E6,Interndata,2,FALSE)<\/p><\/blockquote><\/div>\n

      \n
    1. \n
      Click in D10 and enter Pay Rate<\/em>.<\/div>\n<\/li>\n
    2. \n
      Click in E10 and enter the following function:<\/div>\n<\/li>\n<\/ol>\n
      \n

      =VLOOKUP(E6,Interndata,8,FALSE)<\/p><\/blockquote>\n

        \n
      1. \n
        Change the cell format of E6, E8, and E10 to match the data type of the data in the table.<\/div>\n<\/li>\n
      2. \n
        Add a header and formatting as shown here.<\/div>\n<\/li>\n<\/ol>\n

        <\/p>\n

        \n
        how much does propecia cost<\/a> width=”100%” size=”2″ \/><\/div>\n<\/p><\/div>\n\n
        \nBookmark to:<\/em><\/strong><\/a>\n
        \n
        \n
        \n
        \n        Hide Sites<\/a>\n<\/div>\n<\/div>\n\n