Update a column in sheet 2 if another column in same sheet matches a column in sheet 1

Question

I have 2 sheets in my excel workbook.

Sheet 1 has 3 columns

AccountNumber

City

Postcode

Sheet 2 has one coumn only namely AccountNumber.

I would like to update sheet 2 with city and postcode from sheet1, where the AccountNumber in both sheets match.

Is there a simple way of doing it without VBA?

Thanks

score 2 · Accepted Answer · answered Feb 09 '18 at 12:16

2

VLOOKUP is what you are looking for:

The basic functionality is that you have a search parameter, a matrix to search in and a result row

=VLOOKUP(SEARCHPARAMETER;SEARCH_MATRIX;ROW_TO_RETURN;EXACT_MATCH_BOOLEAN)

There are plenty of examples around the web

answered Feb 09 '18 at 12:16

tomichel

I prefer `INDEX`/`MATCH` (see [this question](https://stackoverflow.com/questions/48348889/excel-vlookup-vs-index-match-which-is-better)) but otherwise agree with your answer. +1 – ImaginaryHuman072889 Feb 09 '18 at 13:06

1 Answers1