VLookUp mismatched key data — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily

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