If you are saying that the formula is showing up instead of the results it's because the cell is formatted as text. Go into format cells and format it as general, the enter the formula. As far as your look up, you say you are trying link the index number from the census file to the index column on the revenue file, but the index file is blank. If I understand correctly, you're trying to populate the index field in the revenue file with what is in the index field in the census file, based on the patient account? Your lookup value in your table array(Census 0904'!A:B,) must be in column A. =20 Christine -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Viola R Robinson Sent: Thursday, November 11, 2004 12:05 PM To: mso@xxxxxxxxxxxxx Subject: [mso] VLookUp Could someone help me please? I am trying to do a VLookup. Why does this=20 message keep apperaing instead of the expected result? =20 =3DVLOOKUP(B2,'Census 0904'!A:B,2,false) =20 I am trying to link the index number from the census file to the index column (blank) on the revenue file. =20 Position of columns on the Revenue File: 1. Index (Blank Column) =20 2. Patient Account =20 Position of columns on the Census File: Position of columns on the Revenue File: 1. Index (Populated w/index number) =20 2. Patient Account Thank you in advance. You kindness is greatly appreciated. Viola R. Robinson Total Outsourcing Network Coalition of Healthcare Administrative Management Professionals Phone: (215) 549-4015 Fax: (215) 924-8777 consumer@xxxxxxxxxxxxxxxxxxxxxx http://www.heavyweightpartner.com =09 --------------------------------- Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ************************************************************ * You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to=20 mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************ * ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************