Results 1 to 4 of 4

Formatting Issues with Inventory Spreadsheet

Threaded View

  1. #1
    Registered User
    Join Date
    05-06-2011
    Location
    Galveston Island
    MS-Off Ver
    Excel 2003
    Posts
    12

    Red face Formatting Issues with Inventory Spreadsheet

    Good Morning my friends. NBVC if you happen to be reading this, I hope this is not breaking a rule by wanting a certain moderator for help. I am so confused and the last time you helped me, my human errors were solved and the best part is I understood. However, I am needing a little more assistance. What I need for this spreadsheet to work efficiently is to have just Item Number and Color Code typed in and the UPC, Item Description, and Price Per Unit to automatically display.

    IF($D23="","",INDEX(Price!B:B,MATCH($D23,Price!$H:$H,0)))

    The formula above you helped me with allows for me to use only one reference (i.e. UPC number) to fill in the other cells. I am needing (I suppose) a dual reference type of formula. I don't really know all the names of formulas other than writing out a word problem and then matching a formula. lol. I have so many reference books in front of me and all of them are a hot second away from being tossed into a barrel and set on fire. And First on the List is Microsoft's Office 2003 Advanced Specialist Approved.
    Best regards

    IsleTurbo
    Attached Files Attached Files
    Last edited by IsleTurbo; 05-25-2011 at 01:28 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