The How-To Geek Forums Have Migrated to Discourse

How-To Geek Forums / Microsoft Office

Vlook up help

(2 posts)
  • Started 4 years ago by mel2131
  • Latest reply from moreeg
  • Topic Viewed 596 times

Posts: 1

So hopefully I will explain this right, i dont seem to be able to attach a print screen

Sheet one has columns A, B, C
Sheet two has C and D

I want to match these two by the first few letters in B (from sheet 1) and D (from sheet 2)

And to display the results in sheet 2 so that I can also see C

Some of them may not match. Whatever I am doing my formula is not working. Any help from anyone would be VERY much appreciated.

Posted 4 years ago
Posts: 842

Hi Mel

Here's one way to do it.

Insert a new column in Sheet1 that will become the new Column A
In that column enter this formula

=Left(C1,3) where the 3 is the number of characters you want to match

in sheet2 column E enter this formula


Again the LEFT statement will need to contain the number of characters you want to evaluate.

Give this a try and see if it gets you what you need. As I said, this is only one approach that can be taken.

Posted 4 years ago

Topic Closed

This topic has been closed to new replies.