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?
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?
if(left(A3,8)=a1,concatenate(a3,a2),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks