Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What's the VBA syntax to replicate this? [email protected] Excel Discussion (Misc queries) 3 August 10th 06 03:52 PM
How do I export information from FileMaker and still display zero. caram Excel Discussion (Misc queries) 0 April 26th 05 11:04 PM
Replicate right from A2,A3,A4 TO B1,B2,B3 etcetera Juice Man Excel Worksheet Functions 5 January 24th 05 02:29 AM


All times are GMT +1. The time now is 07:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"