+ Reply to Thread
Results 1 to 1 of 1

Formula required using vLookup & if statement

  1. #1
    Registered User
    Join Date
    02-23-2013
    Location
    stourbridge england
    MS-Off Ver
    Excel 2011 mac
    Posts
    1

    Formula required using vLookup & if statement

    Heeeelp!!!

    I've created a workbook for my expense claims, with various sheets in Excel for Mac 2011.

    Spreadsheet 1 contains dates in column A, values in column Q & R and text in column S.

    Screen Shot 2013-03-26 at 16.10.57.jpg

    Spreadsheet 2-14 relate to each month and are named Jan - Dec. I need to create a formula to automatically pull the data entered in Spreadsheet 1 (columns A, Q, R and S) through to the corresponding month tabs in Sheets 2-14.

    Screen Shot 2013-03-26 at 16.12.40.png

    I hope there is a simple solution out there to help a novice.

    Regards, Kevin
    Last edited by kevinjlowe; 03-26-2013 at 12:52 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1