Solved: OFFSET and MATCH formula not working

[akamax_power]

Why doesn't this formula work?

=OFFSET(TOOLS!$B$ & MATCH('Summary Sheet 1'!$C$6,Category,0),0,1,1)

I get a formula error when i try to enter this. Am I missing something or just going about it the wrong way?

Thanks,
Gerald

[Bob Phillips]

Explain what it is supposed to do, it is syntactically broken.

[akamax_power]

Cell C6 on 'Summary Sheet 1' is tied to a defined range 'Category' that's listed on sheet 'Tools' in column 'B'. The cell that the formula is entered in is supposed to display the value of column 'C' on sheet 'Tools' based on what's selected in 'Summary Sheet 1'!C6.

IE. 'Summary Sheet 1'!C6 = Earthwork

Sheet 'Tools'

Col B Col C
Earthwork 02100
Sewer 02200
Water 02300


With the formula the resulting value would be '02100'.

Hope this makes sense

[Bob Phillips]

Try

=VLOOKUP('Summary Sheet 1'!C6,'Tools'!B:C,2,False)

[akamax_power]

Perfect!

Thanks