Results 1 to 7 of 7

lookup with IF LEFT function?

Threaded View

  1. #1
    Registered User
    Join Date
    01-09-2019
    Location
    Toronto
    MS-Off Ver
    2010
    Posts
    4

    lookup with IF LEFT function?

    Hello,

    I'm new to the site although I've referred to it a number of times and find it very useful.
    I'm hoping someone out there has can help me out...

    On the first sheet (Release) that displays store ordering schedules. The cells that have scheduled orders may say something different, but will begin with "Release Order."
    The 2nd sheet (Qty), that has daily ordering quantites for each store.
    On the 3rd sheet, I am using the IF(LEFT function to look at the Release sheet, and if the cell starts with "Rel" populate the cell with the corresponding quantity from the Qty sheet.
    This only works if stores and dates on the first two sheets are all aligned the same.

    Is there a way to do this with a lookup by store?
    I've attached an example of the data in the workbook (hopefully I did it correctly).
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] lookup going left based on function
    By bj in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 07:05 PM
  2. [SOLVED] lookup going left based on function
    By Ted Metro in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  3. [SOLVED] lookup going left based on function
    By Ted Metro in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  4. lookup going left based on function
    By Ted Metro in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 02:05 PM
  5. lookup going left based on function
    By bj in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 04:05 AM
  6. [SOLVED] lookup going left based on function
    By Ted Metro in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. [SOLVED] lookup going left based on function
    By Ted Metro in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  8. [SOLVED] lookup going left based on function
    By Ted Metro in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2005, 04:05 PM

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