Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What's the VBA syntax to replicate this? | Excel Discussion (Misc queries) | |||
How do I export information from FileMaker and still display zero. | Excel Discussion (Misc queries) | |||
Replicate right from A2,A3,A4 TO B1,B2,B3 etcetera | Excel Worksheet Functions |