Question

1 Match a 'like' in Column A with a job in Column B. There are three extra jobs in Column B. Column A: I like... 0 cooking food 1 danger 2 fixing things 3 creating things 4 working with animals 5 driving around alone 6 helping people's health 7 working with numbers H Column B: Jobs A bike courier B fire-fighter C receptionist D mechanic E accountant F farmer G waiter H chef I artist J shop assistant K doctor​

Answer 1

0 - H chef

1 - B fire-fighter

2 - D mechanic

3 - I artist

4 - F farmer

5 - A bike courier

6 - K doctor

7 - E accountant

Answer 2

To match the "likes" in Column A with the corresponding jobs in Column B, you can use a VLOOKUP or INDEX-MATCH formula in Excel or Google Sheets. Assuming your data starts from cell A1 and ends at cell B10, here's how you can do it:

In an empty cell, you can use the following formula:

=INDEX(B1:B10, MATCH(A1, A1:A10, 0))

Copy this formula down for each row in Column A where you want to find the matching job. This formula will look for the "like" in Column A and return the corresponding job from Column B.

Here's how it works:

1. MATCH(A1, A1:A10, 0) searches for the value in cell A1 within the range A1:A10 and returns the relative position of the match (i.e., the row number where it's found). The last argument, 0, specifies an exact match.

2. INDEX(B1:B10, ...) takes the row number returned by the MATCH function and retrieves the corresponding job from Column B.

So, if you put this formula in an empty cell next to each "like" in Column A, it will provide you with the matching job from Column B.