Afternoon all.
I've got another of those Excel problems that's probably really easy, but I just can't work out.
I think I need to use VLookup, but not sure if that'll do what I'm after.

I've got two worksheets, each with a table with several thousand rows.
Table 1 has 8 columns, the first 4 are text strings, the second 4 are numbers.
Table 2 just has 4 columns, which are text strings.
For each row in table 2, I want to lookup the same combination of 4 text strings in table 1, then return the 4 number cells for that row.

I know I can use VLOOKUP for a single value, but my complication is that I need to lookup a combination of values, and return a combination of values.
Do I need to concatenate all my columns first?