Relational coding
I have two Excel sheets. There are some materials with their prices in the first sheet and each material has a code. In the second sheet we have some products. Each product needs one or more than one material (as in the first sheet).
I want to connect these sheets. I should be able to enter the material code in the second sheet and the name of the material should appear automatically. Also I'm entering the quantity of materials for each product and the cost should be calculated too.
Note:
I'm a programmer and know that this is so easy to handle in Access. But I want to do it in MS Excel.
With a layout as shown in the example and the range in Sheet1 named array =VLOOKUP(A2,array,2,FALSE) should show in ColumnC the value from the Sheet1 cell immediately to the right of the value as specified in A2 (of Sheet2). The same formula in D2 with ,2, replaced ,3, should give the corresponding unit price, so appending *B2 should give the Cost. Both formulae may be copied down to suit:
- Count the value of the current stock in excel
- How to Save DataFrame to Excel file using filedialog as SaveAs-Dialog in Python?
- Excel MS365: 2-D dynamic array creation problem
- Search the latest saved PDF file in a various folders and copy the latest one to a specific location
- How do I get all the different unique combinations of 3 columns using VBA in Excel?
- Worksheet names in VBE
- Excel macro to identify 0 crossing of the value
- VBA Characters.Delete string over 255 characters
- Using Excel, return 1 for all values >0 WITHOUT using an IF
- How can I convert text in a cell to a sequence of ascii code values with a separator in Excel 2016 or LibreOffice?
- How do you copy and paste entire row of source sheet to destination when a date appears in specific column?
- Excel Chart title will not accept a date concatonated to a string
- filter out multiple criteria using excel vba
- Convert Excel Column Number to Column Name in Matlab
- Consolidate and sum values based on multiple conditions VBA
- Excel number format to only show decimals when necessary
- How to Merge Rows values into a Column on a prior Row?
- Sumif times (datetime format) are greater than 22:30
- Private Sub for hiding worksheets based on cell value "View" / "Hidden"
- Power Query Filtered Rows based on value
- EDI translator to excel
- If formula (the sum is less than 30 then roundup tp 30)
- Unable to use a dynamic named range as a data series - what am I doing wrong?
- How to get the path of current worksheet in VBA?
- vba + copy sheet from one wb to another wb
- Is it still not possible to open Excel from a Word Add-In?
- Excel-365 functions don't work as expected
- Sum values based on three criteria and transpose result from tabular to visual layout
- How to use fraction string in Excel/Calc/Sheets as formula
- VBA Code Save in Local and Upload to Sharepoint