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

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

steve the fish

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

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

Forum statistics

Threads
1,089,668
Messages
5,409,630
Members
403,273
Latest member
Yandos

This Week's Hot Topics

Top