Nov 17 2020 12:48 PM
Hi,
I hope someone can help me with this Formula
=IF(COUNTIFS('2018'!$B$2:$B$2125,B2)>0,'2018'!$C$2:$C$2125,"No")
I am looking for B2 in the sheet 2018. If found I want to return the value from column C in that sheet.
The formula is returning a number from column C but it is not the adjacent cell to the match.
Can someone help please?
Berniews
Nov 17 2020 01:06 PM
Nov 17 2020 02:12 PM