Excel: filter table rows by specified column value

Question

I have a table with first column as primary key. Ex:

id  value1  value2
1       10      5
2       2       3
3       12      5
..

I also have a second list of id's I want to select, which can have repeated ids. Ex:

selectId
1
2
2
2
5
10
..

How can I "merge" the two tables (something like INNER JOIN) to obtain:

id  value1  value2
1       10      5
2       2       3
2       2       3
2       2       3
5       99      99
10      22      22
..

I tried using 'Microsoft Query' from Data > Extern Data to join the two tables. The problem is that it seems it cannot handle tables with more than 256 columns.

Thanks

UPDATE:

Thanks, VLOOKUP works as intended.
However one problem is that if the row was found but that corresponding column was blank, this function returns 0 (where I expected it to return an empty cell), and since zero is a valid value, I have no way to differentiate between the two (blank and zero)? Any help is appreciated..

Answer 1

It is not clear where you store your data, but it looks like you have this problem, described on Microsoft site: http://support.microsoft.com/kb/272729

Answer 2

If this is Excel -like the title says- just use vlookups. Not very relational, but that's the Excel way.