How to Create lookup tables in Excel

Simple and quick video, thanks for sharing!

"too many arguments in this function"

It helped me a lot, although this video it's explained for those that have a basic experience in Excel.

Simple?

For beginners, what the video doesn't do is tell you how the table got there from the start. A table is not just a spreadsheet with headers. You have to insert a table first from the Insert tab. You do this by clicking anywhere in the rows and columns of your "table" array and type Ctrl-A to automatically select the rows and columns of the array. Then on the Insert Tab, click the "Table" icon. A "Create Table" dialog box pops up with its given dimensions. Click OK and it will be given a default name such as "Table1". Finally, the hidden Table Tools Design tab will magically appear showing you the assigned name in the Table Name field on the far left. Then the video begins from that point.

hello

Me neither, CTRL, A did not allow me to name my table.

It seems the lookup value is only in the first column in your "Data" table.

Looks easy but didnt work for me ,, i must be doing something wrong