Urgent help with formula please!!

[targus92]

Hi everyone,

Can you please help me with a formula in the sheeet attached.

I am building a model and need help with a fomula that operates similar to an index match. In the sheet BD-01, this represents a zone. I will be having several zones similar to this. I need to find a fomula that matches and pulls D6 to D14 in the land budget tab (as C2 is BD-01) and pull that into D4 to D12 in the BD-01 tab. I need this dynamic enough where it matches the BD-01 since I will have all the way up to BD-14 and will have several tabs and will be using the formula to pull many pieces of data.

Please let me know if any of the above is unclear and I can calrify further.

Thanks

[AliGW]

Duplicate thread closed. Continue in your original thread: https://www.excelforum.com/excel-for...dex-match.html

And exercise a little patience, please: this is not a 'service', it is a forum manned by volunteers giving freely of their spare time. Thanks.