Lookup data from another tab

Shazz

Board Regular
Joined
Oct 28, 2010
Messages
136
Hi All, I have data in the following columns on Sheet 2, On Sheet 1 I want to Type the Name in A42 and have the data in Sheet 2 in Column B show in A43 and the data in Sheet 2 in Column C show in B43.

Column A = Name
Column B = Title
Column C = Location

Can anyone help please.

Shazz
x
 

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
7,823
Office Version
365
Platform
Windows
VLOOKUP will do what you want, eg:

=VLOOKUP(A42,Sheet2!$A:$C,2,0)
 

Forum statistics

Threads
1,085,425
Messages
5,383,595
Members
401,839
Latest member
kmoon

Some videos you may like

This Week's Hot Topics

Top