Formula help

[Peter1973]

I am using the formula :
=VLOOKUP(B6,Sheet2!C4:C30,4,FALSE)

I thought this would look in cell B6 then look in sheet2 and enter the info in the relevant cell from column 4, but I keep getting the result #REF.

Someone help....

 

[texasalynn]

I am using the formula :
=VLOOKUP(B6,Sheet2!C4:C30,4,FALSE)

I thought this would look in cell B6 then look in sheet2 and enter the info in the relevant cell from column 4, but I keep getting the result #REF.

Someone help....

=VLOOKUP(B6,Sheet2!C4:F30,4,FALSE)

you have to change the table array to include the column you want to return data from. So the 4 would be F.

 

[Smitty]

It should be C4:F30.

By using 4, you're telling it to look outside of the Lookup range when defined as C:C.

HTH,

Smitty

 

[acw]

Hi

try


=VLOOKUP(B6,Sheet2!C4:F30,4,FALSE)

This will find the value from B6 in sheet2c4:c30, the bring back the value from column F that matches. If there is no exact match for the item, it will return an error.


HTH

Tony

 

[Peter1973]

Is there any way I could expand on this formula so that instead of looking in sheet2 it looks into cell A1 then uses the formula to mathc the sheet that matches A1 ?

 

[barry houdini]

Try

=VLOOKUP(B6,INDIRECT("'"&A1&"'!C4:F30"),4,FALSE)

where A1 contains the relevant sheet name