Lookup formula that is restricted to names

[riggsy]

Hi,

I am having trouble coming up with a formula to look up the characteristics of two depths in one table from two depths in another table; the formula below works if the point ID is the same, however I need something that can work across all point ID's, and was wondering if a VBA or a macro might be the solution (see attached table 2 for formula, and Table 1 for the characteristic/origin location).
Table 1.PNGTable 2.PNG


Thanks

[Pepe Le Mokko]

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

[riggsy]

Sorry, please see the attached sample excel for reference, the cells with the calculations are is worksheet GOSA.

Thanks