Hi all,

I am trying to figure out how to modify a formula. At the moment i have

=VLOOKUP(A3,INDIRECT(F3),8,FALSE)
Which is looking in column 8 in a seperate sheet in my workbook. on occasion there is no data in column 8, and as such the formula returns a 0.
Is there any way of getting the formula to search in column 9 if a 0 is returned.

Hope this is clear.

Thanks in advance!