1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Using VLOOKUP to fill in cells, missing a step

I have a spreadsheet with a blank column C on page 1. Column D is filled with a list of seven-digit numbers.

On page two, I have a list of seven-digit numbers, some of which are also in Column D on page 1.

I want to write a VLOOKUP to display a short phrase in Column C on page 1 if the number in Column D is also present on page 2.

I was shown how to do this, but didn't write down the steps because I am a fool.

submitted by /u/ConsiderateCassowary
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article