If cell A1 match b:b, vlookup(C1,D:D,1,False)

[trimiii]

Fellas,

I need a help please..

In cell A1 I have a date (5Sep2020)
In column B:B I have daily dates for my mission (1 - 31 Sep 2020)
In column C1 I have ticket number (111)
In column D:D, I have list category "Im mission", Stand by... etc

I need help with how can I match if cell A1, match B;B than vlookup for C1, column D:D.

I am using the formula: =If (index(b:b,a1),vlookup(c1,d:d,1,false) but it doesn't work.

any idea please?

 

[mikerickson]

In A1 you have a date, in B:B you have a list of dates, in C1 you have a ticket number, in D:D you have a list of categories.

Where do you have a list of ticket numbers?

 

[Joe4]

Is this what you are looking for?

=IF(COUNTIF(B:B,A1)>0,VLOOKUP(C1,D:D,1,FALSE),"")

If not, please post a small sample of your data so we can see what you are working with.

 

[trimiii]

in column f:f

 

[Joe4]

I think it would beneficial to see a data sample along with your expected results.
You can post screen images using this tool here: XL2BB - Excel Range to BBCode

 

[trimiii]

Ok, let me try again,
please see picture...

A;A - daily dates
B:B - ticket numbers
C:C - daily status

in the cell G5, when I enter the date, I need result for that date as showing in the example

 

[trimiii]

color code is just to identify the cells values,

 

[Fluff]

If you have the new filter function, how about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I
1
2	01/09/2020	111	Corbar
3	01/09/2020	112	Limestone Peak
4	01/09/2020	113	Queensbury
5	01/09/2020	114	Cote Heath				02/09/2020
6	02/09/2020	111	Barms			111	112	113	114
7	02/09/2020	112	Queensbury			Barms	Queensbury	Temple	Manifold
8	02/09/2020	113	Temple
9	02/09/2020	114	Manifold
10
Main

Cell Formulas
Range	Formula
F6:I7	F6	=TRANSPOSE(FILTER(B2:C9,A2:A9=G5))
Dynamic array formulas.

 

[mikerickson]

Autofilter on columns A:C will get those results.

 

[trimiii]

this is a little bit complicated but it works.

THANK YOU ALL