fixing formula function if not show right data

[abdelfattah]

hello i need fixing formula or alternative it gives my the result in image2 to in column e not right it supposes some data gives me booking but all of them not booking
so the image 1 sheet's name Room Reservation and sheet's name image 2 available so if col c ,d = col j,k in sheet Room Reservation in image 1 then the result in col e booking in sheet available else no booking

=IF(OR(C26="";D26="");"";IF(AND('Room Reservation'!$K$2:$K$6000=$C26;'Room Reservation'!$J$2:$J$6000=$D26);"booking";"no booking "))

 

[Fluff]

How about
=IF(OR(C26="";D26="");"";IF(AND(isnumber(match($C26;'Room Reservation'!$K$2:$K$6000;0));isnumber(match($D26;'Room Reservation'!$J$2:$J$6000;0)));"booking";"no booking "))

 

[abdelfattah]

hi, fluff

this is what i got

the right result it supposes this

 

[Fluff]

In that case please post your data using the XL2BB add-in, images are useless.

 

[abdelfattah]

image1

Hotel Reservation Daily000 .xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	Booking No	Guest Name	Guest Phone	Guest Country	Guest ID	Check In	Check Out	Adult Guests	Children Guests	Room Type	Room No
2	1	MAIRAJ	29038423	India		12-Jun-20	15-Jun-20	1	1	Standard	102
3	2	MARYAM	2348203	Pakistan		12-Jun-20	15-Jun-20	2	0	Standard	108
4	3	Shanza Waseem	239423	USA		12-Jun-20	15-Jun-20	2	1	Superior	125
5	4	Adeeba Kanwal	2342432	England		12-Jun-20	15-Jun-20	1	1	Superior	120
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
Room Reservation

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:K1000	Expression	=AND($B2<>"";$G2<TODAY())	text	YES
A2:K1000	Expression	=AND($B2<>"";$F2<TODAY();$G2>TODAY())	text	YES

image to

Hotel Reservation Daily000 .xlsm
	A	B	C	D	E	F
5			Room No	Room Type	Status
6			101	Standard
7			102	Standard
8			103	Standard
9			104	Standard
10			105	Standard
11			106	Standard
12			107	Standard
13			108	Standard
14			109	Standard
15			110	Standard
16			111	Superior
17			112	Superior
18			113	Superior
19			114	Superior
20			115	Superior
21			116	Superior
22			117	Superior
23			118	Superior
24			119	Superior
25			120	Superior
26			121	Superior
27			122	Superior
28			123	Superior
29			124	Superior
30			125	Superior
31			126	Superior
32			127	Superior
33			128	Superior
34			129	Superior
35			130	Superior
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
Available

Cell Formulas
Range	Formula
C11:C35,C7:C9	C7	=+C6+1
E31:E36	E31	=IF(OR(C51="",D51=""),"",IF(AND(ISNUMBER(MATCH($C51,'Room Reservation'!$K$2:$K$6000,0)),ISNUMBER(MATCH($D51,'Room Reservation'!$J$2:$J$6000,0))),"booking","no booking "))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C6:D1004	Expression	=AND($B6<>"";$F6<TODAY())	text	YES
C6:D1004	Expression	=AND($B6<>"";$E6<TODAY();$F6>TODAY())	text	YES

 

[Fluff]

You're formula in E31 is looking at C & D on row 51, it should be looking at the same row (ie 31)

 

[abdelfattah]

now i understood why always the members ask insert the image by xl2bb it shows the ranges what use by formulas thanks for your correcting me it works

 

[Fluff]

You're welcome & thanks for the feedback.

 

[abdelfattah]

hi, fluff

i found missing something in my formula an i'm sorry about it in the beginning i thought issue a new post , but i'm afraid delete it because the same data that's why i comment in this post again so i have problem in image 1 in col g this date is linked with date (today) after date(today) it should be not booking but in my formula stays booking after date(today)

 

[Fluff]

How about
=IF(OR(C6="",D6=""),"",IF(COUNTIFS('Room Reservation'!$K$2:$K$6000,C6,'Room Reservation'!$J$2:$J$6000,D6,'Room Reservation'!$F$2:$F$6000,"<="&TODAY(),'Room Reservation'!$G$2:$G$6000,">="&TODAY()),"booking","no booking "))