# Formula help

#### Peter1973

##### Well-known Member
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....

### Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
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.

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

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

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 ?

Try

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

where A1 contains the relevant sheet name

Replies
3
Views
370
Replies
12
Views
329
Replies
2
Views
339
Replies
2
Views
288
Replies
8
Views
145

1,219,917
Messages
6,150,946
Members
450,996
Latest member
darko1515s

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back