Excel

Hi Holly,

Thank you for your question. Apologies for the late response, I've been on sick leave, which has left my colleagues quite stretched work-wise. Vlookup would indeed be a good function to use here if your version of Excel doesn't have Xlookup. You could also use Index and Match, if this was covered in the course you attended.

Just make sure that the account names in each table match exactly with the other table, i.e. no extra characters or spaces in one but not the other.

If you need further assistance, please post again.

Kind regards
Marius Barnard
STL