Results 1 to 22 of 22

Formula Vlookup help

Threaded View

  1. #1
    Registered User
    Join Date
    07-22-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    15

    Formula Vlookup help

    I have created an excel invoice that uses vlookup to the orders page. The item number references to the receipt number which references to the first value over 1. I have this formula figured out. What I am having problems with is the second value because it has to find the second value greater than 1. For me this is a huge and complicated formula and I was wondering if if can be done easier. This will also get more complicated when it needs to find the third or fourth positive value.
    Attached Images Attached Images

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