Results 1 to 9 of 9

Excel 2007 : have Vlookup pull from 2 sheets in the same cell

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-02-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    255

    have Vlookup pull from 2 sheets in the same cell

    I have it pulling from from sheet but I need it to grab information from another if we put information that attains to the other sheet. The formula I have now is:

    =IF(ISBLANK(C3),"",VLOOKUP(C3,'R:\[02-23-2012 Raw Apples.xlsx]Processing'!$A$3:$AD$8000,5,FALSE))

    I need it to grab from the same document but a different sheet, the sheet name is Juice instead of Proccessing. Also the document title was changed to 2-28-2012 but my formula didn't, it stayed on the 2-23, that won't be a problem. It seem to still work.
    Last edited by srgtennis; 02-28-2012 at 01:36 PM.

Thread Information

Users Browsing this Thread

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

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