How to replicate a funstion I use in Filemaker Pro
 

In FileMaker Pro I have a file with several pieces of music, each one
with a code. When I write the code, the program brings the text with
the piece name.
In another file I have student names and by writing the code the piece
to be performed in a recital appears next to the student name.
People who don't have FileMaker Pro want to do the same in Excel. I
can not find a way to do it. COuld anyone find a way for me to pass
along?
Beatriz

How to replicate a funstion I use in Filemaker Pro
 

You would use a VLOOKUP function to do this. There are 4 parameters -
the first is the lookup value (i.e. your code, assume this is in A1).
The second parameter is the table that you want to lookup (this will
be your file, arranged with your code in the leftmost column of the
table). The third parameter is the column number of the table that you
want data returned from if there is a match, and the final optional
parameter (TRUE or FALSE) determines if you want an exact match. The
formula would look something like this:

=VLOOKUP(A1,[filename]sheetname!A$2:B$200,2,0)

Hope this helps.

Pete

On Feb 22, 12:28 am, wrote:
In FileMaker Pro I have a file with several pieces of music, each one
with a code. When I write the code, the program brings the text with
the piece name.
In another file I have student names and by writing the code the piece
to be performed in a recital appears next to the student name.
People who don't have FileMaker Pro want to do the same in Excel. I
can not find a way to do it. COuld anyone find a way for me to pass
along?
Beatriz