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.