VLOOKUp Help

**Dancaw** · 07-24-2009, 06:16 AM

Hi All,

I have searched for this problem prior to posting and tired many solutions, but i just cant seem to get the correct formula to work, I give in.

I need to Display some information in a cell "C7" on sheet "Input" the information
needs to look at Cell C4 & C5. these need to be the lookup value.

the array would be on the second sheet "DuctworkSizes" $A:$C then the information it returns would be in column C (3)

I Can get the formula to work if i just use one Lookup_Value but not with 2.

Sample Code: =VLOOKUP(C4,DuctworkSizes!A2:C22,3,FALSE)

I've Tried =VLOOKUP(C4:C5,DuctworkSizes!A2:C22,3,FALSE) Doesnt Work

I've Tried =VLOOKUP(C4&C5,DuctworkSizes!A2:C22,3,FALSE) Doesnt Work

I've Tried =VLOOKUP((C4:C5),DuctworkSizes!A2:C22,3,FALSE) Doesnt Work

any Help would be really appreciated.

**sweep** · 07-24-2009, 06:31 AM

Could you please post an example of your data?

**martindwilson** · 07-24-2009, 06:50 AM

c4&c5 should work but you might need to include any space
c4&" "&c5

**Dancaw** · 07-24-2009, 07:11 AM

Martin Tried to used those and they dont work, please see screen shots of examples

First Picture is the input screen with the formula shown in the formula bar

\1

this is the Ductworksizes sheet showing the array.

\1

**sweep** · 07-24-2009, 07:16 AM

Simplest thing to do is to add a "helper" column in the Duckworksizes sheet concatenating columns A and B (eg C1=A1&B1). Then use that column as the lookup table array.

**Dancaw** · 07-24-2009, 07:36 AM

Dave,

Tried that. Must be missing something In DuctworkSizes Sheet I Added the header Helper and then put the following formula in all way down.

=A2&B2 and it would give me a value of 0.21.5

so back on the input sheet i added a invisible cell and did the same C6=C4&C5

Which adds the two cells together depending on what ever value user enters. then in C7 value i added =VLOOKUP(C6,DuctworkSizes!C2:C22,4,FALSE) and i get the #REF!