Vlookup, with ifs and nesting

[kz4gl7]

I am having an issue with finding the correct syntax to utilize the vlookup where two criteria are met if the first vlookup returns no data. so I was thinking something like
find host on datatableA, - if there is an address value (not blank), display it; if not, then look for the host {still on datatableA}, but if the host is there AND zone is equal to "a" - then display the address value, if not on DatatableA.. then do the same lookups on DatatableB, and DatatableC... if still not found... display " not found"

here is my thought; please let me know if i am going down the correct path - or not;
iferror(vlookup(A2,[datatable]sheetA!$C,3,false),AND(if(and(vlookup("a",[datatable]sheetA!$C,2,false),vlookup(A2,[datatable]sheetA!$C,3,false)))..........


sheet-matrix
A
host
1 T123


data table:
sheetA
host zone address
T123
T123 a 456

SheetB
host zone address
T444 123

SheetC
host zone address
T555 123
T555 b 456

 

[etaf]

=IFERROR(vlookup-1,IFERROR(vlookup-2,IFERROR(vlookup-3,"NOT FOUND")))

 

[kz4gl7]

=IFERROR(vlookup-1,IFERROR(vlookup-2,IFERROR(vlookup-3,"NOT FOUND")))

forgive my ignorance, but I am not following the above; where does the "AND" logic fit in for the second IFERROR

 

[etaf]

dont know
can you explain what the AND is doing exactly in your OP
I may have misread the original question

 

[kz4gl7]

sure; essentially I want to vlookup the address value first if the condition is met, great; but if not; add a second condition to the vlookup statement where the formal looks for the first condition adding the value in the zone field for the vlookup