Hello.
In Sheet1 I have table with 2 columns. The first column contains the names of over 350 materials and the second one contains the weight of each material in the first column.
I want to make in Sheet2 an empy table with two columns, and every time I type on column one, the name of a material from Sheet1, the weight of the material should automatically appear on column 2.
How can this be done?
Multiple conditional formatting
Multiple conditional formatting
Open Office 4, Windows 7 Ultimate
Re: Multiple conditional formatting
It is not related to the Conditional Format feature.
You can achieve this by usage of the VLOOKUP() function.
Use the ISBLANK() function, if you want empty cells on the unfilled area.
If the typed-in material is located in the column A:
- where the Sheet1.$range is the sheetname and the data range on the sheet1.
Finally drag the formula down.
You can achieve this by usage of the VLOOKUP() function.
Use the ISBLANK() function, if you want empty cells on the unfilled area.
If the typed-in material is located in the column A:
Code: Select all
=IF(ISBLANK(A1;"";VLOOKUP(A1;Sheet1.$range;2;0) Finally drag the formula down.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.