Lookup Question

[Can_This_Be_Don]

Not sure how to set up this vlookup so am seeking advice. In cell G1 a code will be entered. I then need to look in the table (cells A1:C8) if it is found, to look at the day and carry the corresponding time to column H against the appropriate day.

To give you a better understanding G1 shows LSA03, in the table it finds the matching record, to the left it then finds the day, then the value in C4 is shown in H4.

The data I'm showung is only an example but I'm struggling to get the vlookup to work correctly.

Book1
	A	B	C	D	E	F	G	H
1	Day	Duty	Start			Duty	LSA03
2	Mon	LSA01	09:00				Mon
3	Tue	LSA02	10:45				Tue
4	Wed	LSA03	12:30				Wed	12:30
5	Thu	LSA04	14:15				Thu
6	Fri	LSA05	16:00				Fri
7	Sat	LSA08	17:45				Sat
8	Sun	LSA9	19:30				Sun
Sheet1

 

[starl]

Try this:

Book1
	A	B	C	D	E	F	G	H
1	Day	Duty	Start			Duty	LSA03
2	Mon	LSA01	9:00				Mon	FALSE
3	Tue	LSA02	10:45				Tue	FALSE
4	Wed	LSA03	12:30				Wed	12:30
5	Thu	LSA04	14:15				Thu	FALSE
6	Fri	LSA05	16:00				Fri	FALSE
7	Sat	LSA06	17:45				Sat	FALSE
8	Sun	LSA07	19:30				Sun	FALSE
Sheet1

 

[starl]

=IF(G2=OFFSET($A$1,MATCH($G$1,$B$2:$B$8,0),0),OFFSET($A$1,MATCH($G$1,$B$2:$B$8,0),2),"")

I added the ,"" at the end so you can have blanks if there's no match

 

[NBVC]

Why not,

In H2
=If($B2=$G$2,$c2,"") copied down.

 

[starl]

Because mine is more complicated and fancier

When you get into the complexity mode...
*blush*

 

[NBVC]

Because mine is more complicated and fancier

When you get into the complexity mode...
*blush*

Good enough reason for me