Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Trying to get results from multiple columns

So, the exact situation is: I've got a list of common names and taxonomic info (order, family, etc.) in Columns A-F (with common names in Column A), and another (shorter) list of common names in Column G. All of the names in G are in A. Both lists are in the correct (taxonomic) order, and need to stay that way.

I want to be able to search for the values in G out of the list in A, and then have it give me the whole shebang (A-F) in Column "H-L." I really don't care if this is exactly where it ends up; it's going to be cut and pasted from here, so I need it to give me actual values, not just functions in the cells. So for instance, "Turkey Vulture" in G4 would give H4:"Cathartiformes" I4:"Cathartidae" J4:"[empty]" K4:"Cathartes" L4:"Cathartes aura" rather than =MATCH() or =VLOOKUP() in the cells.

I've tried VLOOKUP and MATCH, but neither one seems to work unless I reference the list in Column G for output, which of course doesn't work past the common name.

click to hide/show revision 2
retagged

Trying to get results from multiple columns

So, the exact situation is: I've got a list of common names and taxonomic info (order, family, etc.) in Columns A-F (with common names in Column A), and another (shorter) list of common names in Column G. All of the names in G are in A. Both lists are in the correct (taxonomic) order, and need to stay that way.

I want to be able to search for the values in G out of the list in A, and then have it give me the whole shebang (A-F) in Column "H-L." I really don't care if this is exactly where it ends up; it's going to be cut and pasted from here, so I need it to give me actual values, not just functions in the cells. So for instance, "Turkey Vulture" in G4 would give H4:"Cathartiformes" I4:"Cathartidae" J4:"[empty]" K4:"Cathartes" L4:"Cathartes aura" rather than =MATCH() or =VLOOKUP() in the cells.

I've tried VLOOKUP and MATCH, but neither one seems to work unless I reference the list in Column G for output, which of course doesn't work past the common name.