+ Reply to Thread
Results 1 to 2 of 2

compare 2 colume

  1. #1
    Registered User
    Join Date
    09-19-2007
    Posts
    1

    compare 2 colume

    I have 3 columns

    A1
    00-00-00
    00-00-34

    A2
    text
    text

    A3
    00-00-00-12-23-45-fd
    00-22-11-dr-23-45-sd

    the value on A1 need to be found on A3 and if is true add the value from A2
    I’m using vlookup but is not working any advice?

  2. #2
    Forum Contributor
    Join Date
    02-28-2006
    Posts
    690
    if(left(A3,8)=a1,concatenate(a3,a2),"")

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1