VLOOKUP Value Not Working

Hey everyone!

Do I have any hair left? I guess I'm about to pull it all out.
I'm trying to apply a VLOOKUP function to my schedule sheet. Attached to this post is a copy of the sheet.

The shifts that I'm entering in B7:AC7 should be looked up in the table located at K21:Q25. I'd like the looked up value to display in B8:AC8.

I have tried many things, put in different values but it won't work. I'm sure someone here can make it work.

I thank you in advance!

Daniel

Your list has a colon : after the lookup value.. you need to remove that or include in the Vlookup formula.. also, your merged cells are confusing it is column 6 you are trying to extract from. And you should make table range absolute (add $ signs) so that you copy across the formula without changing the reference.

Try:

=VLOOKUP(B7&":",$K$21:$Q$25,6,FALSE)

copied across

Seems quite closely related to your earlier question Dunda: http://www.excelforum.com/excel-prog...ng-values.html

B8, any of:

=SUMIF($K$22:$K$25,B7&":",$P$22:$P$25)

=VLOOKUP(B7&":",$K$22:$P$25,6,0)

=INDEX($P$22:$P$25,MATCH(B7&":",$K$22:$K$25,0))

Your formula is looking for a value in Column 16 of the table, there is no column 16 & you are using Merged Cells which can cause problems

=SUMIF('Hours'!$K$22:$K$26,B7,'Hours'!$P$22:$P$26)