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" :

REFERENCE	ROOM1	ROOM2	ROOM3	ROOM4
Column C	Column D	Column E	Column F	Column G
f123456	100,000	100	50	25
f123457	200,000	200	100	50
f123458	300,000	300	150	75
f123459	400,000	400	200	100
f123460	500,000	500	250	125
f123461	600,000	600	300	150
f123462	700,000	700	350	175
f123463	800,000	800	400	200
f123464	900,000	900	450	225
f123465	1,000,000	1000	500	250

<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>

Worksheet1:

ROOM1	ROOM2	ROOM3	ROOM4			REFERENCE	ROOM1	ROOM2	ROOM3	ROOM4
Column Q	Column R	Column S	Column T	Column U	Column V	ColumnW	Column X	Column Y	Column Z	Column AA
399,000	405	210	90			f123459	no	yes	yes	no
						f123460
						f123461
						f123462
						f123456
						f123457
						f123458
						f123463
						f123464
						f123465

<colgroup><col><col><col span="3"><col><col span="5"></colgroup><tbody>
</tbody>

 

[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!

CELL	FORMULA
Y3	=IF(VLOOKUP($P3,info!$C$2:$G$11,COLUMNS($P3:Y3),0)<U$3,"Yes","No")<u4,"q","uq"),"")< td=""></u4,"q","uq"),"")<>

<tbody>
</tbody>

 

[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