Help! I’m not sure what functions I need to use!

[Jhannis3]

Hi,

I have a spreadsheet for work with bookings in it, there’s multiple columns but I need to transfer data from one cell to another based on the following

IF column A has a certain date in it AND column B has a certain time in it AND column C has a certain word in it then I want it to take the information from the row in column D which has all the column A,B,C matches in it (there should only ever be one row where all 3 match).

I’ve tried a combo of vlookup as well as IF,AND etc.. but nothing is quite working!

Any suggestions would be very gratefully received!

 

[JazzSP8]

Sounds like you need to create a Helper Column and do your VLOOKUP on that.

So perhaps insert an new Column A and then use =B1&C1&D1 to create a unique key of the values (You can hide this Column if you don't want it visible).

Then use your VLOOKUP to look in Column A and retrieve the value in Column E

If you need to do you can use VLOOKUP like;

=VLOOKUP(CertainDate&CertainTime&CertainWord,A:E,5,False)

Replace the CertainDate, Time and Word with actual vales or cell references, it is the "&" you need to link them all.

 

[jtakw]

Hi,

You can also use an Array Entered INDEX/MATCH, confirmed by CSE (Control, Shift, Enter, instructions below):

Book1
	A	B	C	D	E	F
1	12/5/2018	12:00	word	bingo		bingo
2	12/5/2018	1:00	word	miss
3
4	Date	12/5/2018
5	Time	12:00
6	Word	word
Sheet379

Cell Formulas
Range	Formula
F1	{=INDEX(D1:D2,MATCH(B4&B5&B6,A1:A2&B1:B2&C1:C2,0))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Jhannis3]

Thanks so much to both of you. I think I’ve managed to do what I needed with both of yours help!

 

[jtakw]

You're welcome, glad to help.