98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Integrating data from more than one spreadsheet | Excel forum
Integrating data from more than one spreadsheet | Excel forum
Resolved · Low Priority · Version 2003
Elaine has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Integrating data from more than one spreadsheet
How do I perform a v look up
RE: integrating data from more than one spreadsheet
Hi Elaine, Welcome to the forum, Thank you for your question; in response -
Lookup functions are used to extract a result from a table of data, to extract the information you will need to provide a lookup value (search criteria), this should be in a separate cell and should refer to a value or label from column/row 1 in the table, the Lookup function will then look for the intersection of this row or column with an indicated row or column, and will return the value or label.
Lookups are either Vlookup or Hlookup, (Vertical or Horizontal).
The syntax for a Vlookup table would then be; =VLOOKUP(Lookup_value,Database_cell_range,Column_to_search,Type_of_Lookup Type of lookup can be either TRUE or FALSE.
If TRUE is indicated, the values must be sorted in ascending order, Lookup will then return the value equal to or less than the search criteria from the intersecting cell.
I hope that helps, regards Pete.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Move data worksheet to worksheetTo move data from one worksheet to another, highlight the data. |