A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Problems with Match function



 
 
Thread Tools Display Modes
  #1  
Old April 6th 17, 08:07 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Problems with Match function

I have used the match function many times for various reasons, but have recently encountered a problem that I cannot get passed. I have a list of values that contains the following values (wire sizes):

14
12
10
8
6
4
3
2
1
1/0
2/0
3/0
4/0
250
300
350
400
500
600
750
1000

When I first enter the function in one cell and another cell that contains the search value, it works perfect. However, one I change the search value to one containing "/" or that is on the "other side" of the "/" the function returns "#N/A" every time unless I enter one of the "/" values. To clarify, if I start with any of the values 14-1, it works as long as I stay at the top of the list. As soon as I enter anything from 250-1000, it goes to "#N/A". After that, the only time it finds anything is if my search value is 1/0, 2/0, 3/0, or 4/0. I have tried forcing to text format (both the list and the search value) and that doesn't help. Has anyone else seen this or have a suggestion to address this issue?
Ads
  #2  
Old April 7th 17, 07:32 AM
gmail_gia_re gmail_gia_re is offline
Junior Member
 
First recorded activity by ExcelBanter: Jan 2017
Posts: 1
Default

nghe được đấy cái n*y có giao h*ng t*n nơi không nhỉ để em l*m một cái
_________________
thi công sơn epoxy

https://t.co/Lr42DB6xJC
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
IF , match formula problems treeroot Excel Worksheet Functions 1 September 25th 08 06:33 AM
Match problems excelent Excel Programming 3 July 24th 06 03:15 PM
Match and Lookup problems Titanus Excel Worksheet Functions 4 April 6th 06 08:46 PM
match problems mike allen[_2_] Excel Programming 1 August 3rd 04 03:34 AM
Problems with Match function Tom Excel Programming 4 November 24th 03 07:03 PM


All times are GMT +1. The time now is 01:18 PM.


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