1 / 28

Using VLOOKUP with Safari ODBC

Using VLOOKUP with Safari ODBC. October, 2006. Example Using Excel. Click Data Import External Data New Database Query. Select Data Source. Enter Password. argus.mecdc.org. Select Available Tables. Select the files and fields you wish to pull data for.

owena
Download Presentation

Using VLOOKUP with Safari ODBC

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Using VLOOKUP with Safari ODBC October, 2006

  2. Example Using Excel • Click Data • Import External Data • New Database Query

  3. Select Data Source

  4. Enter Password argus.mecdc.org

  5. Select Available Tables Select the files and fields you wish to pull data for. Click on Job_Position

  6. Select Fields/Columns you want Use arrows to Arrange order Click Next When done Selected fields Double click to select fields to be included

  7. Filter Data Click Next When done Filter on as many fields/columns as needed

  8. Sort Order Click next When done Sort on as many Fields/columns as needed

  9. Finish Click here to Save your query Click Finish when done

  10. Where do you want the data? Click OK

  11. Retrieves Data from You Files

  12. Create Sheet 2 of Same Workbook • Click on Sheet 2 of same workbook • Click Data • Click Import External Data • New Database Query • Select USPS Database • Enter Username and Password

  13. Select Available Table Select table you want to Use for Sheet 2 DED_ANNUITIES

  14. Select Fields/Columns for Sheet 2 Click Next Make sure you have the same column (SSN) on each sheet to match Data.

  15. Filter Data Click next When done Filter on DED_Code And YTD_DEDUCTED

  16. Sort Data Click next when done

  17. Finish Click here to Save your query Click Finish when done

  18. Where do you want the data? Click OK

  19. Retrieves Data From Your Files

  20. Using VLOOKUP Select entire sheet 2 of the workbook by clicking here

  21. Using VLOOKUP • Click Insert • Name • Define

  22. Using VLOOKUP Click OK Define Name for Sheet, “Master”

  23. Using VLOOKUP On line 2 of the next available column of sheet 1, enter your VLOOKUP command

  24. Using VLOOKUP 1. Enter “=“ Select VLOOKUP

  25. Using VLOOKUP

  26. Using VLOOKUP • =VLOOKUP(A2,MASTER,3,False) • A2 = look in column A, row 2, of sheet 1 • Master = Go to Sheet 2 “Master” and retrieve data • 3 = If match, retrieve data from column 3 of Sheet 2 “Master” • False = If no match enter false

  27. Data Transferred Information from sheet 2 will be pulled into Sheet 1. Click and drag formula to end of sheet.

  28. VLOOKUP • You can transfer information from more than one column on Sheet 2 to Sheet 1. • You can create more than two Sheets and transfer information to Sheet 1.

More Related