Hi,
I need to cross reference between a minimum of two worksheets. I've needed to anonymise the data. I've tried using INDEX and MATCH with structured references and been instructed that these are the functions I need to learn. I need the function to work for at least two sets of data that are not the same size. I need to accomplish quite a few tasks and there are functions in there that I inherited but don't work now possibly because new data in a different format was added.
In tab DATA1 I need column J to look up the period an invoice was paid from the DATA2 worksheet (column C).
In tab DATA1 I need column K (DATA2 budget) to lookup the budget code from column A (Nom.) from worksheet DATA2
In tab DATA1 I need column column L (DATA2 Amount) to look up the invoice amount from column F (Financial Value) in worksheet DATA2.
I need to do all sorts of these lookups but they should all be resolved if I can get on top of the INDEX and MATCH function unless you have better ideas?
I'd really appreciate any help,
Thanks.
Bookmarks