How to cell which cell a VLookup references?

[ransomedbyfire]

As I mentioned in another thread, I am trying to improve a rather complex workbook for someone. The person who set up the workbook used a lot of VLookups throughout the whole thing, and I am having trouble figuring out which cell some of the VLookups are referencing.

For example, one says =IF(ISERROR(VLOOKUP(A10,SheetName!$A$3:$P$18000,14,FALSE)),0,
VLOOKUP(A10,SheetName!$A$3:$P$18000,14,FALSE))

Am I right in thinking that VLOOKUP(A10,SheetName!$A$3:$P$18000,14,FALSE should refer to SheetName!N10?

This makes no sense because SheetName!N10 doesn't even contain information relevant to the cell that the VLookup is listed in. (In fact, I can't find a column in SheetName that contains relevant-looking data for this cell. How can I find out what's going on here?

Thanks in advance for your help!

 

[Aladin Akyurek]

Do some additional reading on VLOOKUP...

VLOOKUP(A10,SheetName!$A$3:$P$18000,14,FALSE)

looks up A10 in the table A3:P18000 on the sheet with SheetName as name. The result
this formula returns comes from the 14th column of the table. That corresponds to N3:N18000 on SheetName.