Register
How do you work out a lookup and an if function on an excel spreadsheet?
204k views
2 votes
How do you work out a lookup and an if function on an excel spreadsheet?

User Corbin
by
8.7k points

1 Answer

1 vote
In column A, put the codes of the products to look up. In column B, put the product name. In column C, put the price.
User Sven Delmas
by
8.5k points
← Prev Question Next Question →

Related questions

User Shyamupa
asked Apr 21, 2019 8.9k views
How are lookup tables useful to business analyzing data in a spreadsheet
Shyamupa asked Apr 21, 2019
by Shyamupa
8.0k points
2 answers
4 votes
8.9k views
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

9.4m questions

12.2m answers

Other Questions

The book shows how to add and subtract binary and decimal numbers. However, other numbering systems are also very popular when dealing with computers. The octal (base 8) numbering system is one of these.
Seven basic internal components found in a computer tower
describe an advance in technology that makes life more enjoyable. what discoveries contribute to this technology?
What is an example of a dedicated computer system?
Allow the user to enter a series of temperatures in degrees Celsius (C) ter- minated by the input of –999. For each one, find the corresponding tem- perature in degrees Fahrenheit (F). The conversion formula
Link Copied!