Log In
Register
Home
New Member
June 9, 2021
Offline
I wanted to know how to search the with another cell and then compare another 2 cell
e.g. I have A1 "Apple" to search the Row E have "Apple or not , if found then compare B1 and C1 to compare Row F and G is same or different.
I have other 2 formula but I want one formula to find the result
formula 1
=IF(ISNUMBER(SEARCH($B3,Compare_Summary!Q:Q)), "Find", "Not Found")
formula 2
=IF($B23<>Compare_Summary!L23,"File not Exist ",IF(AND($C23=Compare_Summary!M23, $D23=Compare_Summary!N23),"Compare info with Intranet is same","File Exist, Date: "&Compare_Summary!M23&", Size: "&Compare_Summary!N23))
VIP
Trusted Members
December 7, 2016
Offline
Hello,
It is easier for everyone if there is a sample file showing the data structure to look at, can you share such file?
Br,
Anders
New Member
June 9, 2021
Offline
Hi Anders,
I have more then 200000 column to compare for path , date and size for each site, but not every column is live, so I wanted to use site 1 to compare other site by path and show result.
Thanks
1 Guest(s)
