Results 1 to 6 of 6

Nested vlookup with possible if statement

Threaded View

  1. #1
    Registered User
    Join Date
    04-18-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    34

    Nested vlookup with possible if statement

    I have an invoice spreadsheet that has several segments of billing data. I need to lookup 1 piece of the segment to another table and pull in the commodity description to a commodity column. I thought of delimiting the billing data but the issue is all segments are separated by dashes and some of the location names have dashes in them so the data won't delimit correctly. Attached is a sample of what I have.

    For this example I want to lookup the commodity in column A of the data spreadsheet, find the match in column A of the commodity tab, and bring the value from column B of the commodity tab to column B of the data tab.

    Thanks for your help.
    Attached Files Attached Files
    Last edited by LilSisKin; 02-02-2016 at 11:44 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  2. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 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