How to auto-populate values in a column based on a lookup table?

Hi there! I've looked at this a number of ways, trying INDEX / MATCH / VLOOKUP and more, and the only function which seemed like it might do what I need is XLOOKUP, which is not available in Excel 2010.

I have attached a sample spreadsheet, but, in essence, what I am trying to do is have the values in one column auto-populate based on the text in another field in the same row. This formula would then be cut and pasted for each field in that column.

In looking at my attached spreadsheet:

Column A lists where I took a trip. This is the column which needs to be searched to determine which value should auto-populate in column B.

Columns C and D are informational and irrelevant here.

Columns F and G are my lookup table (F7:G10). The formula in Column B should look for each string in F7:F10 and, if it gets a positive return for an entry in column F, return the value from the same row in Column G.

Does anyone know a way to achieve this in Excel 2010 please?

Thanks in advance!

Originally Posted by AliGW

Welcome to the forum.

Thank you! And... wow! That's exactly what I was looking for! What does the IFERROR part do please?