SEARCH

The How-To Geek Forums Have Migrated to Discourse

How-To Geek Forums / Microsoft Office

Vlook up help

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

mel2131
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 1 year ago
Top
 
moreeg
moreeg
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

=VLOOKUP(LEFT(C1,3),Sheet1!$A$1:$D$4,4,FALSE)

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 1 year ago
Top
 



Topic Closed

This topic has been closed to new replies.

Get Free Articles in Your Inbox!

Join 134,000 newsletter readers

Email:

Go check your email!