0
How do you write a formula in Excel for if a field has a specific value then go to this field and find said value and return data from corresponding field?
Wiki User
∙ 8y ago
Your question is a bit unclear. However, you may need to use the VLOOKUP function or the INDEX and MATCH functions. Check up these functions as they may provide what you need to do your task.
Wiki User
∙ 8y ago
Add your answer:
Earn +20 pts
Excel makes reading formulas simpler each cell reference in the formula and its corresponding cell in the worksheet?
color coding
What is the formula for sound on spreadsheet?
There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.There is no specific formula or function for sound in Excel. As there are mathematical formulas for sound, like ones for speed of sound in water or in air, you can use Excel to do the calculations if you know what those formulas are.
How useful is the vlookup in Excel computation?
Vlookup is a complex but useful function in Excel. It allows you to search through tables for a value and return a corresponding value. It is one of a set of functions that enables you to search data and find values. See the related question below.Vlookup is a complex but useful function in Excel. It allows you to search through tables for a value and return a corresponding value. It is one of a set of functions that enables you to search data and find values. See the related question below.Vlookup is a complex but useful function in Excel. It allows you to search through tables for a value and return a corresponding value. It is one of a set of functions that enables you to search data and find values. See the related question below.Vlookup is a complex but useful function in Excel. It allows you to search through tables for a value and return a corresponding value. It is one of a set of functions that enables you to search data and find values. See the related question below.Vlookup is a complex but useful function in Excel. It allows you to search through tables for a value and return a corresponding value. It is one of a set of functions that enables you to search data and find values. See the related question below.Vlookup is a complex but useful function in Excel. It allows you to search through tables for a value and return a corresponding value. It is one of a set of functions that enables you to search data and find values. See the related question below.Vlookup is a complex but useful function in Excel. It allows you to search through tables for a value and return a corresponding value. It is one of a set of functions that enables you to search data and find values. See the related question below.Vlookup is a complex but useful function in Excel. It allows you to search through tables for a value and return a corresponding value. It is one of a set of functions that enables you to search data and find values. See the related question below.Vlookup is a complex but useful function in Excel. It allows you to search through tables for a value and return a corresponding value. It is one of a set of functions that enables you to search data and find values. See the related question below.Vlookup is a complex but useful function in Excel. It allows you to search through tables for a value and return a corresponding value. It is one of a set of functions that enables you to search data and find values. See the related question below.Vlookup is a complex but useful function in Excel. It allows you to search through tables for a value and return a corresponding value. It is one of a set of functions that enables you to search data and find values. See the related question below.
What are color coded formula references in Excel?
To make it easier to see what parts of a formula refer to what cells or references on a worksheet, the cell references in the formula are shown in colour and highlights around the cells are in the corresponding colours.
A predefined formula a formula that excel has already built for you. that performs calculations by using specific values in particular order?
It is a function
Why does Microsoft Excel delete or forget the formulas you make?
It does not. You need to press ENTER after entering the formula to ensure the formula stays in the cell. If you have a specific situation, please ask another question which is more specific.
What do you have to put in a cell to denote an equation in Excel?
In Excel an equation can be a formula. All formulas in Excel must start with the equals sign. That is what tells Excel it is a formula.
What is vlook up?
Vlook up is the formula in microsoft excel to search the list of items vertically to find out specific information.
What is an excel file?
When you create a spreadsheet or workbook then a corresponding file is created on your machine, that file is known as excel file.
Where is the formula error button in Excel 2007?
There is no formula error button in Excel. However, there is an Error Checking button on the Formulas ribbon in the Formula Auditing section in Excel 2007.
What is the formula for PVIFA in Excel?
The PVIFA formula in excel refers to Present Value Interest Factor of Annuity. This is able to be calculated in an excel document.
What is replicating a formula in Excel?
Replicating means copying. So replicating a formula in Excel is copying a formula. This is a very common activity that is done in Excel. You create one formula and then use it in other places on the worksheet.
