Excel

[Tanya Kruger]

Hi There



On the first picture (Data) including the amount is the branch that I want to insert automatically.

I have the Terminal ID's in one colunm and the Branch in another as you can see in picture 2 (ID Keys)

This is a bank statement that I have to add each branch in every month.
I do not want to type the branch in every time.

Is there an easier way to insert the branch into my bankstatement?
All this is on excel and I can insert colunms if I need to.

Kind regards,
Tanya

[vieome]

You could use Vlookup in excel. Attached a small example



Sheet 1 will be statement. Sheet 2 will be fixed with branch numbers and Terminal ID.

[Tanya Kruger]

Hi Vieome

Wow, thank you so so much.
You will never know how long I've been trying to do this.
I just realized that I did not understand how the vlookup was working.
Always struggled with it.