Grab from one table and insert into another minus empty fields

**purdue7997** · 10-26-2010, 05:53 AM

Need help from the pros!

Attached is a draft smaller scale copy of what I'm trying to accomplish. Basically I have a mass field that has names in one column with an associated mission number in a second column. Not all rows will contain a name or mission number but the format must stay intact (not filter/sort). There is more to the actual spreadsheet than just the example.

In another section on the spreadsheet a mini "window" will show what names have been entered along with the mission numbers.

My question is, how do I capture the names and msn numbers in say cells B2:C25 and then display them in cells G12:H20 omitting all empty entries?

Thanks in advance!

**JBeaucaire** · 10-26-2010, 09:00 AM

Put this in H12 and copy down:

=IF(G12="", "", VLOOKUP(G12, B:C, 2, 0))

**purdue7997** · 10-26-2010, 10:25 AM

Originally Posted by JBeaucaire

Put this in H12 and copy down:

=IF(G12="", "", VLOOKUP(G12, B:C, 2, 0))

I would need cells G12:G20 to auto fill in as well though. Cells G12:H20 will auto create whatever is inside cells B2:C25, omitting any empty cells.

**JBeaucaire** · 10-26-2010, 10:52 AM

The inclusion of a "key" column next to your data creates a quickly matchable index that can be used to create your smaller table in realtime. Like shown.

This allows the sheet to function without the need of macros, and the key columns can be hidden if desired.

**purdue7997** · 10-26-2010, 11:09 AM

Originally Posted by JBeaucaire

The inclusion of a "key" column next to your data creates a quickly matchable index that can be used to create your smaller table in realtime. Like shown.

This allows the sheet to function without the need of macros, and the key columns can be hidden if desired.

Pure genius! Thanks JBeaucaire! Thread solved and Rep given!