Forum Discussion
Gavin145
Apr 14, 2020Copper Contributor
Linking list to get a price
I have a simple excel database for my business accounts. I have a customers sheet which has customer information name and price they pay . I also have an accounts sheet that consists of date (A), customer (B), monies (C), and total amount (D). In the accounts sheet there is a list that links to the customer sheet. what I would like to be able to do in the monies (C) cells is to have the customers price (from the customer sheet) automatically put in when the customer is chosen in customers (B).
Does anyone have any idea how to do this?
1 Reply
- Riny_van_EekelenPlatinum Contributor
I'd suggest you have a look at the VLOOKUP or XLOOKUP functions. The latter only works in the latest Excel version.