Can you post a table in email of what your data looks like? Ray ------------------------------------ GR Business Process Solutions Ray Blake Head of Software Design ray@xxxxxxxxx Braedon Newell Road Hemel Hempstead Herts HP3 9PD tel: 01442 396518 fax: 01442 389353 mobile: 07834 226601 www.grbps.com ------------------------------------ -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Graham Jones Sent: 24 May 2006 16:55 To: 'mso@xxxxxxxxxxxxx' Subject: [mso] Re: Excel2003/WinXP I'm afraid that doesn't change the result of 1 -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of ohtechie Sent: 24 May 2006 15:45 To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Excel2003/WinXP not sure if it matters much but replace the 0 with false =vlookup("Honda",D4:H19,5,False) -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On Behalf Of Graham Jones Sent: Wednesday, May 24, 2006 10:12 AM To: 'mso@xxxxxxxxxxxxx' Subject: [mso] Excel2003/WinXP I have a table with 15 motorcycle names in column D and the number sold in column H. In a cell elsewhere on the spreadsheet, I want to show the number of Hondas sold and think I need VLOOKUP but it don't get the correct result, 7, with =VLOOKUP("Honda",D4:H19,5,0), I get 1. ************************************************************* 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, visit the group's homepage and use the dropdown menu at the top. This will allow you to unsubscribe your email address or 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 If you are using Outlook and you see a lot of unnecessary code in your email messages, read these instructions that explain why and how to fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm ************************************************************* ************************************************************* 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, visit the group's homepage and use the dropdown menu at the top. This will allow you to unsubscribe your email address or 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 If you are using Outlook and you see a lot of unnecessary code in your email messages, read these instructions that explain why and how to fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm *************************************************************