Software

Ask something
Discussion Locked

Data Lookup in Excel

0 helpful
3 replies

by techwine

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Can someone explain to me what a "data lookup" is in Excel? Also how do I assign a print macro in Excel? Thanks!

3 replies

by charles byrne

I'm guessing you're referring to Vlookup function.
It works with a list where the lookup value is in the 1st column and the list is sorted. Example:

=Vlookup("612",$A$1:$C$10,3,False)

The 1st argument "612" is what you want to Find.
The 2ndargument $A$1:$C$10 is the lookup table.
The 3rd argument 3 is the column you want returned.
The 4th argument False indicates you want an exact match (true is the closest match).

See Help for more details.

This discussion is closed to new replies.