Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+training+course - V lookup
|
|
|
The UK's most regular 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. |
microsoft+excel+training+course - V lookup
Resolved · Low Priority · Version Standard
Reply Wed 24 Oct 2007, 13:48Delegate Tamara said...
Tamara has attended:
Excel Intermediate course
Excel Introduction course
Excel Advanced course
V lookup
how do i do this?
For upcoming training course dates see: Pricing & availability
Reply Wed 24 Oct 2007, 13:54Delegate Paul said...
RE: v lookup
vlookup looks for a certain bit of data in a range of cells and returns a column in that range
if you have a list of customer numbers and you want excel to look for the customer's surname, you can do something like this in cell B2:
=vlookup(A2,Sheet2!A:C,3,0)
looks for whatever is in cell A2 in the range of column A to column C on sheet 2 and returns the 3rd column in the range (column C)
|