General discussion

Locked

Data Lookup in Excel

By techwine ·
Can someone explain to me what a "data lookup" is in Excel? Also how do I assign a print macro in Excel? Thanks!

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Data Lookup in Excel

by Charles Byrne In reply to Data Lookup in Excel

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.

Collapse -

Data Lookup in Excel

by techwine In reply to Data Lookup in Excel

Poster rated this answer

Collapse -

Data Lookup in Excel

by techwine In reply to Data Lookup in Excel

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums