Help with Vlookup formula

[Dhiren Sheth]

Hello,

I am trying the get the phone numbers for respective stores in my worksheet from another tab in the same worksheet and I selected the range but when I drag the formula down to other cells the range also changes. The formula I used is as under:
=VLOOKUP(D3,'McDonalds Rest List'!$B2:$I1442,7,FALSE)
When I drag it down the range changes from B2 to B3 and I 1442 to I1443 and so on so forth.

Can someone help please....

Thanks
Dhiren

 

[Aladin Akyurek]

Hello,

I am trying the get the phone numbers for respective stores in my worksheet from another tab in the same worksheet and I selected the range but when I drag the formula down to other cells the range also changes. The formula I used is as under:
=VLOOKUP(D3,'McDonalds Rest List'!$B2:$I1442,7,FALSE)
When I drag it down the range changes from B2 to B3 and I 1442 to I1443 and so on so forth.

Can someone help please....

Thanks
Dhiren

Try...

=VLOOKUP(D3,'McDonalds Rest List'!$B$2:$I$1442,7,0)

FALSE and 0 are interchangeable here.