CODEWITHSUNDEEP
excelvba
user5223227
user5223227

Reputation:

How to check if value exists in other sheet, then output value from another cell in the row

I am completely stumped here and don't know the proper spreadsheet terminology.

So I have one sheet which has the following three columns

Now the post ID refers to the ID of the post the comment was created on.

I have a second sheet (in the same workbook) that has the following columns:

How can I run a formula that makes Excel replace the values in 'Comment Post ID' with the correlating titles?

Thanks!

Upvotes: 0

Views: 15124

Answers (1)

Hoejanson
Hoejanson

Reputation: 134

Say the Comment items are on Sheet 1 columns A:C and the Post items are on Sheet 2 columns A:B, in order, with headers.

In Sheet 1 column D Row 2 use

=VLOOKUP(B2,Sheet2!A:B,2,FALSE)

You can drag that down as far as your data goes and it will lookup the Comment Post ID from Sheet 1 column B to find the matching title in Sheet 2 Column B.

If you really want to replace your Comment Post ID column with the titles then just copy and paste the values of your new column D

Upvotes: 2

Related Questions