Results 1 to 4 of 4

How to combine IF, VLOOKUP and MATCH?

Threaded View

Shreyaanand How to combine IF, VLOOKUP... 09-23-2015, 04:36 AM
NeedForExcel Re: How to combine IF,... 09-23-2015, 04:41 AM
Sam Capricci Re: How to combine IF,... 09-23-2015, 04:43 AM
Shreyaanand Re: How to combine IF,... 09-23-2015, 05:55 AM
  1. 09-23-2015, 04:36 AM #1
    Shreyaanand is offline
    Registered User
    Join Date
    09-23-2015
    Location
    Chennai, India
    MS-Off Ver
    2007
    Posts
    9

    How to combine IF, VLOOKUP and MATCH?

    If A2 is equal to any rows in Sheet 2 column A, then return the value of Sheet 2 Column 2, else return the value of Sheet 1 Column D.

    Coloured boxes are the places where I need to populate data from Sheet 2
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do I match and combine data using VLookup?
    By sunshine123 in forum Excel General
    Replies: 11
    Last Post: 05-04-2015, 11:19 PM
  2. [SOLVED] INDEX & MATCH for approximate matches or combine VLOOKUP & HLOOKUP
    By michaljireht in forum Excel General
    Replies: 4
    Last Post: 12-01-2014, 08:41 PM
  3. How to Combine/Match Sku's and Qty
    By plank22 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-01-2014, 10:55 PM
  4. [SOLVED] Match & Vlookup combine?
    By Laurianne03 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-07-2013, 04:20 PM
  5. combine 2 ranges and match
    By jpbisani in forum Excel General
    Replies: 2
    Last Post: 01-01-2012, 09:40 AM
  6. How to combine IF, VLOOKUP and MATCH?
    By stormracela in forum Excel General
    Replies: 9
    Last Post: 05-17-2010, 03:17 AM
  7. Match & combine
    By Michael Wise in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2008, 02:59 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1