Hello everyone
I have the following two formulas which work fine, but I want to combine them into one formula.
My goal is to place a formula into H5 of sheet1, which first looks for the value G5 (sheet1) in sheet2 (column C) and if found checks if the value in C5 (sheet1) is the same as the value in column S (sheet2).
If yes then it should return TRUE, if no then FALSE.
Either the G5 or the C5 value can occur several times in sheet2, but the combination of the two is unique.
Is there a way to achieve that without VBA?
Thanks in advance for any help.
I have the following two formulas which work fine, but I want to combine them into one formula.
VBA Code:
=IF(ISERROR(VLOOKUP(G5,'SHEET2'!$C$2:$C$1001,1,FALSE)),FALSE,TRUE)
=IF(ISERROR(VLOOKUP(C5,'SHEET2'!$S$2:$S$1001,1,FALSE)),FALSE,TRUE)
My goal is to place a formula into H5 of sheet1, which first looks for the value G5 (sheet1) in sheet2 (column C) and if found checks if the value in C5 (sheet1) is the same as the value in column S (sheet2).
If yes then it should return TRUE, if no then FALSE.
Either the G5 or the C5 value can occur several times in sheet2, but the combination of the two is unique.
Is there a way to achieve that without VBA?
Thanks in advance for any help.