Vlookup problem

[Noz2k]

Right so I have a list of values in column B of Sheet 1 which correspond to values in a column F of a sheet named 'Incidents'

What I am trying to call back is the value of the cell in Column Z of the 'Incidents' sheet, however it's not working properly.

the formula I have is

=VLOOKUP($B3,Incidents!$F$2:$Z$3179,21)

Strangely this seems to work for B3, but when I go down a row and the formula is

=VLOOKUP($B4,Incidents!$F$2:$Z$3179,21)

it gives me the same result as the first formula, despite them not being the same on the incidents sheet.

Any idea why this would be?

 

[moonfish]

It's probably because you left out the optional fourth parameter for vlookup.
Regardless, consider using index/match instead of vlookup (it's much faster):

=INDEX($Z$2:$Z$3179,MATCH($B3,$F$2:$F$3179,0))

 

[Noz2k]

Just getting an N/A using the Index/Match formula?

Edit: The Value is definitely there in column F, I copied and pasted it, and used ctrl+f to check

 

[Noz2k]

Just realised it's because I didn't prefix it with the sheet name

All works, thanks