• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

VLookUp mismatched key data

by on
in Excel Training,Office Technology

Q. I want to look up from one column where the data is combined (ABC-123) to another which is separate (A1 =ABC col B1=123). Can I do this with a VLookUp?

A. You’ll need to create a first column on the list where the two fields are separated.

In that column you’d type = A1&”-“&B1, which would yield a cell result of ABC-123, given your example. Now, you can perform the lookup on the new combined column.

 

Leave a Comment