[RESOLVED] Fomula choices?

is there any advantage between these 2 formula? both seem to return the correct result

=INDIRECT(ADDRESS(MATCH("tes",INDIRECT(ADDRESS(1,1,1,TRUE,CONCATENATE(D2," ", E2))):INDIRECT(ADDRESS(99,1,1,TRUE,CONCATENATE(D2," ", E2))),0),3,1,,CONCATENATE(D2," ",E2)))

or

=VLOOKUP("tes",INDIRECT(ADDRESS(2,1,1,TRUE,CONCATENATE(D2," ", E2))):INDIRECT(ADDRESS(99,5,1,TRUE,CONCATENATE(D2," ", E2))),3,FALSE)


any simpler or better solution also welcome
these are not the finished result, just some testing for a sheet i need to do, where values are on several different sheets

seen posted as text here, the second looks like it would have less calls??

Perhaps,

Code:

---

=VLOOKUP("tes",INDIRECT(CONCATENATE("'",D2," ",E2,"'!$A$1:$E$99")),3,FALSE)

---

yes that is simpler, just put the whole range as a string

thnx