Jun 23 2021 12:06 AM
Can someone please help me with a basic formula. I have 5 product codes each with a $ value, and I have 200 rows of information, each time I enter a product code in 1 cell then I would like the value shown in the next cell without having to do a manual calculation each time. Is this possible and what would the formula be please. Thank you for any assistance you can offer in this regard.
Jun 23 2021 12:17 AM
SolutionJun 23 2021 12:25 AM
Jun 23 2021 01:23 AM
Here is my little suggestion for a solution,
I hope that I have understood your instructions correctly.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Jun 23 2021 01:46 AM
Jun 23 2021 02:02 AM
I only prefabricated BEDROOM 1 (column F is the formula),
he takes the cost code from the sheet "Rates".
I left the rest to you :)).
If something is wrong, please inform.
As far as I can see it works for me without any problems.
*Here again the excel file
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Jun 23 2021 12:17 AM
Solution