Excell 07 formula help

June 16, 2009 at 08:31:06
Specs: Windows XP
Can anyone help me determine what formula I need for a spreadsheet? I am trying to find a way (formula) for when I enter text into one column I want predetermined text to appear in another automatically.
So what I am doing is creating a database of fish species. What I want to do is link cells so that when I enter the common name in A1 the scientific name appears in B1. any suggestions?

See More: Excell 07 formula help

Report •

June 16, 2009 at 09:44:18
Assuming you have a list of names, try a VLOOKUP in B1.

With your common names in C1:C10 and the corresponding scientific names in D1:D10, use:


Read up on VLOOKUP in the Help files to see how it works.

Report •
Related Solutions

Ask Question