Results 1 to 4 of 4

Compare text in column B, C match with sheet 2 A:A and get result in E

Threaded View

  1. 04-03-2013, 12:16 AM #1
    Daniel Chang
    Daniel Chang is offline
    Registered User
    Join Date
    11-13-2012
    Location
    Taiwan
    MS-Off Ver
    Excel 2003
    Posts
    9

    Compare text in column B, C match with sheet 2 A:A and get result in E

    Dear all,

    I am looking for a formula, the condition is if the either column B1 or C1 in sheet1 can be found in sheet2 A:A, bring B1 or C1 which matchs sheet2 A:A to column E1, and if there is no matches, put USD in E1. I have attached the template, please help to advise, thanks!
    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)

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