Find data from one sheet to apply in another?

[Nebularlagoon]

Hi,

I am struggling to work out what type of formulae I require.

I have a workbook with 2 sheets. 'Customers' & 'Orders'.

'Customers' contains all customer info and 'Orders' contain all Order info.

Each customer has a discount percentage in the 'customers' sheet but this is not shown in the 'orders' sheet. I want to input the discount percentage to the 'orders' sheet.

The common identifier in both sheets is Column D 'acc' which is the account number.


Column G is where the discount percentage is.

I want to add the discount percentage to column M.


Any help would be really appreciated.

[AliGW]

Welcome to the forum!

Try this on the Orders sheet:

=INDEX(Customers!G:G,MATCH(A1,Customers!D:D,0))

where A1 contains the customer ID on the Orders sheet.

[Nebularlagoon]

Thank you so much this worked! It has been driving me up the wall.

Just one additional question which has arisen now this has been fixed. I am now using a pivot table to show Customer Name, Sales Total, Discount Percentage.

The first 2 columns work fine. But the 3rd column which is the discount percentage is adding all the percentages together. So if a customer has 10% discount and has purchased 3 times then it is showing 30.


Again, thanks ))

[AliGW]

This is a completely different question, but I imagine you need to set the PT up to show each customer just once. If you want further help, attach the workbook.