Results 1 to 4 of 4

Match/Vlookup/Error-type Formula Needed

Threaded View

  1. #1
    Registered User
    Join Date
    07-13-2017
    Location
    California
    MS-Off Ver
    2016
    Posts
    9

    Match/Vlookup/Error-type Formula Needed

    Hello,

    I'm working on adding a failsafe for a sheet that multiple people will work with. I want an ERROR message to pop up if specific values don't match. The values that will be analyzed are based on two other data values matching. I can't get the table to format correctly, but column A is fruit, column B is country, and column C is a percentage.

    For example:
    Column A Column B Column C
    Banana Europe 5%
    Orange South America 5%
    Banana Europe 10%
    Orange Europe 5%

    Row 1 and 3 have the same values for Column A and Column B, but different values for column C. Therefore, I want the formula to result in 5% (if the column A, B, and C values all match) but result in ERROR if Column C does not match (assuming column A and B do match).

    Thanks for any help you can offer!
    Last edited by laurenm; 10-29-2018 at 06:07 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Index Match / Vlookup / Other formula needed
    By rustywrightone in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-18-2017, 10:48 AM
  2. [SOLVED] Error in Vlookup string: A value used in the formula is of the wrong data type.
    By Taylorim in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-20-2016, 08:20 AM
  3. [SOLVED] MATCH | SMALL | IF Formula Error Help Needed
    By chad328 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-06-2016, 08:15 AM
  4. [SOLVED] help needed to write a vlookup, match or combination of both formula
    By spittingfire in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-31-2015, 09:31 AM
  5. [SOLVED] Vlookup or Index Match Formula Needed
    By artiststevens in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-07-2015, 01:09 AM
  6. Nested VLookup, Match Formula Help Needed
    By jealkon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-08-2013, 02:18 PM
  7. [SOLVED] SUMIF/VLOOKUP/COUNTIF type formula needed
    By liam_bettinson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-26-2012, 03:54 AM

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