excel learn london - Vloopuk formulaes

Hi Lukasz

Thank you for your question, and apologies for the delay in responses.

The VLOOKUP function does still work if you are looking up data from another spreadsheet. The main thing to remember it that the lookup value has to come from the leftmost column in the table array that you select.

I hope this helps.
Amanda