VLOOKUP problem

[ERC1985]

I am trying to create a formula which includes IF, ISERROR and VLOOKUP, the data where the VLOOKUP takes it's information from a seperate worksheet which is updated on a weekly basis but I cannot get my spreadsheet to VLOOKUP the most current sheet even though it is using the same link. When I re-enter the formula it still does not accept the updated data sheet and tells me there is an error message as there is blank cell, any ideas? Thank you

 

[anglais428]

Can you post an example? It is difficult to give a response to this from the info you have provided.

 

[ERC1985]

Here is an example of the formula I am using
=IF(ISERROR(VLOOKUP(A31,Admin Information\D.A.R\[D.A.R.xls]Domestic Avail'!$B$312:$G$900,3,FALSE)),"",VLOOKUP(A31,Admin Information\D.A.R\[D.A.R.xls]Domestic Avail'!$B$312:$G$900,3,FALSE))
The same formula was working on a previous sheet but since it has been updated it now doesn't work, even though I have updated the VLOOKUP data/source.

Thank you

 

[Skybluekid]

Forgive me, I might be missing something, I cant see any logical test in the IF statement?

=IF(ISERROR(VLOOKUP(A31,Admin Information\D.A.R\[D.A.R.xls]Domestic Avail'!$B$312:$G$900,3,FALSE)) ,"",VLOOKUP(A31,Admin Information\D.A.R\[D.A.R.xls]Domestic Avail'!$B$312:$G$900,3,FALSE))