Home › Practice questions › VLOOKUP › Question 5

Excel VLOOKUP Practice Question: Customer ID is typed in F1. Find that customer's name and city and put them in…

By Rinkesh Shah, founder of Cellgrids.

The question

Customer ID is typed in F1. Find that customer's name and city and put them in F2 and F3.

The data

	A	B	C	E	F
1	ID	Name	City	ID	C-103
2	C-101	Anita	Pune	Name	?
3	C-102	Bharat	Delhi	City	?
4	C-103	Chetna	Surat
5	C-104	Dhruv	Jaipur
6	C-105	Eesha	Nagpur
7	C-106	Farid	Kochi

The yellow cells are where your answer goes.

Show answer

Expected results:

F2 = Chetna
F3 = Surat

How it works

Explanation: Use the same lookup value with a different column number to pull several details for one ID.
Syntax: =VLOOKUP($F$1,A2:C7,2,FALSE) and =VLOOKUP($F$1,A2:C7,3,FALSE)
F1 is C-103, which is Chetna. Column 2 gives the name Chetna and column 3 gives the city Surat.

Try it yourself in the live sheet

Type your formula in the highlighted cell and get instant feedback. Free, no Excel install needed.

Try this question in the live sheet →

VLOOKUP syntax

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Looks up a value in the first column of a range and returns a value from another column, same row. Pulling an employee's salary into another sheet using their ID. Full VLOOKUP guide.