Excel

Resolved · Low Priority · Version 365

Thu 10 Nov 2022, 10:53 Delegate Holly said...

Holly has attended:
Excel Advanced course

Excel

Hi,

I am trying to use a vlookup for consolidation. I would like it to pick up the values from the P&L and BS accounts (Based on the account name) from 2 different entity's and pull the figures into the consolidation. Is the Vlookup the best formula for this? I have tried Xlookup but its not in the version of excel i have.

Thanks,
Holly

Mon 14 Nov 2022, 13:37 Trainer Marius said...

RE: 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

Mon 21 Nov 2022: Automatically marked as resolved.

Training courses