Community archive

Ask something
Discussion Locked

Linking columns in Excel

0 helpful
3 replies

by poolergirl

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I want to create a spreadsheet for users that will generate a job description in column 2 if a job number in column 1 or vice versa.

3 replies

by dklippert

Check out VLookUp. You can have a table of descriptions - "Jobs" with a number in the left column and then the text.
The formula could be:
=VLOOKUP(A2,Jobs,2,FALSE).
This matches the number in A1 and returns the contents in the same row from column 2. (False assures an exact match)

This discussion is closed to new replies.