answersLogoWhite

0


Best Answer

There is no lookup wizard in Excel. That is something you find in Access, when entering fields. It allows you to link one table to another table or to set a list of values that can be used when entering data. There are a number of lookup functions in Excel, but they do not have wizards associated with them. The lookup functions in Excel are for different purposes than the lookup wizard in Access is for.

User Avatar

Wiki User

9y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How can you use we lookup wizard in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Why use lookup wizard?

You might use Lookup Wizard in order to learn how a the Lookup program works on that particular program. The Wizard walks you through the look up process with each step explained to you.


What are the3 lookup functions in excel 2007?

LOOKUP, HLOOKUP and VLOOKUP.


What is Lookup Wizard?

The lookup wizard allows you to create a field that sources its data from a list of values of a field in another table or query.


What is the breakpoint in Excel?

In excel it is the lowest value for a specific category or series in a lookup table.


Is a look up used in Excel?

Yes. There are 3 main functions for doing lookups. They are LOOKUP, VLOOKUP and HLOOKUP. You can also use a combination of the MATCH and INDEX functions to achieve a lookup.


Is lookup and reference an excel function category?

Yes.Yes.Yes.Yes.Yes.Yes.Yes.Yes.Yes.Yes.Yes.


What are the ways to create charts quickly and easily in Excel?

You would use the Chart Wizard to create them quickly.


What is the function wizard in Excel?

It enables you to choose a function and helps you through the process of choosing the elements you need to use it.


Does the uplookvert function in Excel exist?

There is no function of that name in Excel. There is a function called VLOOKUP which stands for Vertical Lookup, and is probably what you mean.


what company can give you accurate estimation?

Advanceremodeling.com and remodelestimates.com offer free estimates. Or you can use a calculator wizard from excel or cgi.money.cnn.com/tool.renovation.html.


Do the lookup tables in excel not find letters only numbers?

They can be used to search for both letters and numbers.


What combination of actions make creating a chart a simple task in Excel 2010?

Using a chart wizard.