+ Reply to Thread
Results 1 to 3 of 3

Help needed for Vlookup with IF /AND function

  1. #1
    Registered User
    Join Date
    09-03-2023
    Location
    Canada
    MS-Off Ver
    365
    Posts
    1

    Help needed for Vlookup with IF /AND function

    Hello,

    I have one Source file ABC and destination file XYZ, and I want to look up info from Source file and enter the data in Destination file B with (-) 2 cents

    Source file ABC has 2 columns "Location names" & "prices for each location name"

    Destination File XYZ has 1 column of "Locations names" 99% of location names are matching with Source file ABC's.

    list of location names in both Source and destination file in not in exact sequence.

    need a formula in destination file XYZ that can look up same city names from source file and show pricing in the destination with 2 cents less.

    For E.g
    Source file ABC
    Column City Name - New York
    Column Price - $10.02

    Result in Destination File XYZ
    Look up Budapest in this file and source code file, look up price from Source file ABC file "10.02" and show result with 2 cents less as $10 in Destination file.

    I hope I provided clear info to get some help here!

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,910

    Re: Help needed for Vlookup with IF /AND function

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

    A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Help needed for Vlookup with IF /AND function

    You have posted this in the Tips and Tutorial forum, I will more it to a more suitable forum for you
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Help needed - possible Vlookup function?
    By razor001 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-26-2013, 04:12 PM
  2. Function help needed (probably a vlookup?)
    By matchooo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-19-2013, 11:11 AM
  3. [SOLVED] Unique returns for Large Function with VLookup needed
    By James McEwan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-02-2013, 02:04 PM
  4. Vlookup / SumIFS / Other related Function Needed
    By blakey56 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-02-2012, 07:57 PM
  5. Excel 2007 : Index,Vlookup function needed help
    By kalles in forum Excel General
    Replies: 1
    Last Post: 06-08-2012, 08:27 AM
  6. Complex Vlookup/ VBA function or Macro Needed For "if contains text then vlookup"
    By alfykunable in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-09-2012, 03:48 AM
  7. vlookup Function Help Needed
    By jeffc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-14-2006, 07:32 AM
  8. help needed in VLOOKUP function
    By DaredEvil590 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-25-2005, 01:10 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