+ Reply to Thread
Results 1 to 32 of 32

If & Vlookup mixed formula only partly working

Hybrid View

  1. #1
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,934

    Re: If & Vlookup mixed formula only partly working

    Please check the formulae you are given more carefully

    =INDEX(Sheet2!$D$1:$D$6, MATCH(A1&C1, Sheet2!$B$1:$B$6 & Sheet2!$C$1:$C$6,0))
    =INDEX('bill qty'!D2:D831,MATCH(B16&C16,'Receipted qty'!$A$2:$A$831&'Receipted qty'!$C$2:$C$831,0))

  2. #2
    Forum Contributor
    Join Date
    12-08-2015
    Location
    London, England
    MS-Off Ver
    2021
    Posts
    145

    Re: If & Vlookup mixed formula only partly working

    Huge thanks for pointing that out

    Ok so now it's brought back several answes, though unfortunatley i don't recognise the figures its supplying

    In one example it should have brought back an answer of 266.17, instead it's given a result of 1.41

    Can anyone help me with what's happened here?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. conditional candle color but stacking not working and data mixed
    By PaulHOH in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-30-2015, 09:31 PM
  2. VLOOKUP gives Mixed Results
    By wallyclan in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-20-2014, 07:48 PM
  3. Vlookup Mixed
    By dmcbrier in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-25-2014, 12:15 PM
  4. [SOLVED] Partly working macro - variable fails if it holds certain data
    By SoulPrisoner in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-21-2013, 09:10 AM
  5. [SOLVED] Vlookup mixed with IF, looking at a date.
    By galvinpaddy in forum Excel General
    Replies: 16
    Last Post: 06-28-2012, 07:05 AM
  6. Substitute code partly working
    By drewship in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-19-2010, 04:54 PM
  7. I mixed , help me in VLOOKUP()
    By 3Dmajid in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-11-2008, 06:40 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