Conditional Comparision Formula

[hyd1956]

Hi

Could someone please assist with a formula that resolve the following query. Struggling myself as my knowledge of excel is limited. Any assistance would be greatly appreciated.

If Value in Column A ,row 2 = N then display “No change”. If the value in Column A, row 2 = Y, then compare the number in Column B, row 2 vs all rows in Column C, if the numbers match then compare the matching row in Column E vs row 2 in Column A. If they are different then display “Payment Required”. If the value in Column A, row 2 = Y then compare Column B, row 2 vs all rows in Column C, if no match then displays “Payment Required”.

Thank you

 

[Eric W]

Hi

Could someone please assist with a formula that resolve the following query. Struggling myself as my knowledge of excel is limited. Any assistance would be greatly appreciated.

If Value in Column A ,row 2 = N then display “No change”. If the value in Column A, row 2 = Y, then compare the number in Column B, row 2 vs all rows in Column C, if the numbers match then compare the matching row in Column E vs row 2 in Column A. If they are different then display “Payment Required”. If the value in Column A, row 2 = Y then compare Column B, row 2 vs all rows in Column C, if no match then displays “Payment Required”.

Thank you

Welcome to the forum!

I think you meant something different for the value I marked in red, since you've already used the A2 cell for either a Y or an N. But other than that, if I understand your question properly, then this should give you an idea of what you want:

Book1 (version 1).xlsb
	A	B	C	D	E
1
2	Y	12345	11111		1
3	10		22222		2
4			33333		3
5	Payment Required		44444		4
6			12345		5
7			23456		6
8			99999		7
Sheet11

Cell Formulas
Range	Formula
A5	A5	=IF(A2="N","No change",IF(VLOOKUP(B2,$C$2:$E$8,3,0)<>A3,"Payment Required","No Payment Required"))

 

[hyd1956]

Hi Eric,

Thank you for your help.

Some of it is working but I'm having trouble with fixing one bit, in the example below, if the value in column D is not in column C but column F is Y then I also want it show as "Payment Required" (or similar text).

number start ​	number end​	Start ​	End ​	Payment ​
1234 ​	1234 ​	N	Y	Payment Required​
	123456 ​		Y	#N/A

The formula I am using is =IF(F2="N","No change",IF(VLOOKUP(D2,$C$2:$E$26,3,0)<>F2,"Payment Required","No Payment Required"))
Which works for everything else I want. Do you have any suggestions to add in the final fix?

Thanks

 

[Eric W]

I'm struggling a bit since that layout seems a little odd to me, but I think this is what you want:

=IF(F2="N","No change",IFERROR(IF(VLOOKUP(D2,$C$2:$E$26,3,0)<>F2,"Payment Required","No Payment Required"),"Payment Required"))