Results 1 to 7 of 7

HELP: Vlookup using multiple criteria to check values

Threaded View

  1. #1
    Registered User
    Join Date
    06-26-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2007
    Posts
    28

    HELP: Vlookup using multiple criteria to check values

    Hi Guys,

    Have spent ages on this to no avail. Need the attached sheet to verfiy the values in the "Reconciliation" are correct when referencing the "Prices" sheet. I need column F (Reconciliation sheet) to lookup the "Code" in column B in the "Prices" sheet and then further look up the "Payment Frequency" (column D in the Reconciliation sheet) in the "Prices" sheet to verify that the price is correct.

    Due to slight decimal point issues, if the value has a greater than 0.02 difference then display "ERROR" otherwise 0.

    Thanks a thousand times over,
    Jason.
    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. possible to check for file in multiple folders, then check for values in specific cells?
    By mattheritage in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-04-2014, 08:33 AM
  2. Replies: 5
    Last Post: 08-04-2013, 09:49 AM
  3. Select multiple criteria based on check box selection and return all unique values.
    By TommyToe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2013, 09:14 AM
  4. Multiple Criteria - Vlookup for numerical values
    By n_nagesh in forum Excel General
    Replies: 10
    Last Post: 08-28-2009, 08:09 AM
  5. using vlookup tp check for criteria
    By eric_t_viking in forum Excel General
    Replies: 3
    Last Post: 05-29-2009, 03:53 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