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
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

steve the fish

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

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

Forum statistics

Threads
1,089,191
Messages
5,406,724
Members
403,104
Latest member
mkirchner

This Week's Hot Topics

Top