Formula to type YES or NO after compare two cells

[asyamonique]

Hello,
Is it possible to fix that question with a formula?

Worksheets "info" C2:C11" has datas with reference ID numbers.
D2:G11 has digit number values near that ID numbers.
On another worksheet from the cell W2:W500 there are mixed that ID numbers related from C2:C11
My question is to compare those digits with the other digits from Q2:T500 and put text into the other cells (X2:AA500) as YES or No
if incoming Q2 value higher then any values from the worksheet "info" D2:D11 wich same ref ID number from C2:C11 it will be text as YES on X2 cell.
Many Thanks


Worksheet"info" :

[TABLE="width: 392"]
<colgroup><col><col><col span="3"></colgroup><tbody>[TR]
[TD]REFERENCE[/TD]
[TD]ROOM1[/TD]
[TD]ROOM2[/TD]
[TD]ROOM3[/TD]
[TD]ROOM4[/TD]
[/TR]
[TR]
[TD]Column C[/TD]
[TD]Column D[/TD]
[TD]Column E[/TD]
[TD]Column F[/TD]
[TD]Column G[/TD]
[/TR]
[TR]
[TD]f123456[/TD]
[TD]100,000[/TD]
[TD]100[/TD]
[TD]50[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]f123457[/TD]
[TD]200,000[/TD]
[TD]200[/TD]
[TD]100[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]f123458[/TD]
[TD]300,000[/TD]
[TD]300[/TD]
[TD]150[/TD]
[TD]75[/TD]
[/TR]
[TR]
[TD]f123459[/TD]
[TD]400,000[/TD]
[TD]400[/TD]
[TD]200[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]f123460[/TD]
[TD]500,000[/TD]
[TD]500[/TD]
[TD]250[/TD]
[TD]125[/TD]
[/TR]
[TR]
[TD]f123461[/TD]
[TD]600,000[/TD]
[TD]600[/TD]
[TD]300[/TD]
[TD]150[/TD]
[/TR]
[TR]
[TD]f123462[/TD]
[TD]700,000[/TD]
[TD]700[/TD]
[TD]350[/TD]
[TD]175[/TD]
[/TR]
[TR]
[TD]f123463[/TD]
[TD]800,000[/TD]
[TD]800[/TD]
[TD]400[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]f123464[/TD]
[TD]900,000[/TD]
[TD]900[/TD]
[TD]450[/TD]
[TD]225[/TD]
[/TR]
[TR]
[TD]f123465[/TD]
[TD]1,000,000[/TD]
[TD]1000[/TD]
[TD]500[/TD]
[TD]250[/TD]
[/TR]
</tbody>[/TABLE]


Worksheet1:

[TABLE="width: 836"]
<colgroup><col><col><col span="3"><col><col span="5"></colgroup><tbody>[TR]
[TD]ROOM1[/TD]
[TD]ROOM2[/TD]
[TD]ROOM3[/TD]
[TD]ROOM4[/TD]
[TD][/TD]
[TD][/TD]
[TD]REFERENCE[/TD]
[TD]ROOM1[/TD]
[TD]ROOM2[/TD]
[TD]ROOM3[/TD]
[TD]ROOM4[/TD]
[/TR]
[TR]
[TD]Column Q[/TD]
[TD]Column R[/TD]
[TD]Column S[/TD]
[TD]Column T[/TD]
[TD]Column U[/TD]
[TD]Column V[/TD]
[TD]ColumnW[/TD]
[TD]Column X[/TD]
[TD]Column Y[/TD]
[TD]Column Z[/TD]
[TD]Column AA[/TD]
[/TR]
[TR]
[TD]399,000[/TD]
[TD]405[/TD]
[TD]210[/TD]
[TD]90[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]f123459[/TD]
[TD]no[/TD]
[TD]yes[/TD]
[TD]yes[/TD]
[TD]no[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]f123460[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]f123461[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]f123462[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]f123456[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]f123457[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]f123458[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]f123463[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]f123464[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]f123465[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[RasGhul]

Try this in X2, then copy across to AA2 then down;

Book1
	Q	R	S	T	U	V	W	X	Y	Z	AA
1	ROOM1	ROOM2	ROOM3	ROOM4			REFERENCE	ROOM1	ROOM2	ROOM3	ROOM4
2	399,000	405	210	90			f123459	No	Yes	Yes	No
3							f123460	No	No	No	No
4							f123461	No	No	No	No
5							f123462	No	No	No	No
6							f123456	Yes	Yes	Yes	Yes
7							f123457	Yes	Yes	Yes	Yes
8							f123458	Yes	Yes	Yes	Yes
9							f123463	No	No	No	No
10							f123464	No	No	No	No
11							f123465	No	No	No	No
Sheet1

Cell Formulas
Range	Formula
X2	=IF(VLOOKUP($W2,info!$C$2:$G$11,COLUMNS($W2:X2),0))

<q$2,"yes","no")< html=""></q$2,"yes","no")<>

 

[asyamonique]

Thans cool,
Thanks a lot.
How can we keep the cells blank if there is no value at column W cos now if i do not have any values it shows #N/A

 

[asyamonique]

Fixed, with IFERROR!
Thanks again.

<q2,"yes","no"),"")[ code]<="" html=""></q2,"yes","no"),"")[>

 

[RasGhul]

You're Welcome glad it helps

 

[asyamonique]

Hello Again!
Sorry for that but I'm trying to alter some references on my formulas, if I put column W datas to column P
Column Q:T datas to columns U:X
And I want to put the formulas on the cells Y2:AB50
So far I couldn't figure out
Thanks

 

[asyamonique]

That's the alteration I did done but it says #REF!

[TABLE="width: 636, align: center"]
<tbody>[TR]
[TD]CELL[/TD]
[TD]FORMULA[/TD]
[/TR]
[TR]
[TD]Y3[/TD]
[TD]=IF(VLOOKUP($P3,info!$C$2:$G$11,COLUMNS($P3:Y3),0)<U$3,"Yes","No")<u4,"q","uq"),"")< td=""></u4,"q","uq"),"")<>[/TD]
[/TR]
</tbody>[/TABLE]

 

[RasGhul]

Hi

Copy this into Y2 first then drag across and then down, the COLUMNS($X2:Y2) part counts the columns as you move the formula across but your room data starts in Column 2,3,4,5;

Book1
	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1	REFERENCE					ROOM1	ROOM2	ROOM3	ROOM4	ROOM1	ROOM2	ROOM3	ROOM4
2	f123459					399,000	405	210	90	No	Yes	Yes	No
3	f123460									No	No	No	No
4	f123461									No	No	No	No
5	f123462									No	No	No	No
6	f123456									Yes	Yes	Yes	Yes
7	f123457									Yes	Yes	Yes	Yes
8	f123458									Yes	Yes	Yes	Yes
9	f123463									No	No	No	No
10	f123464									No	No	No	No
11	f123465									No	No	No	No
Sheet1

Cell Formulas
Range	Formula
Y2	=IF(VLOOKUP($P2,info!$C$2:$G$11,COLUMNS($X2:Y2),0))

<u$2,"yes","no")[ code]<u$2,"yes","no")<="" html=""></u$2,"yes","no")[>

 

[asyamonique]

Many Thanks