LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default Match Columns Not Working - Formatting?

I am matching two columns on two tabs with results being posted on the first
tab, third column. For some reason, the match does not always work and I
believe it must be the way either it was input or the way it is formatted.
For example, two data items appear to match but do not return a result and
they look exactly the same. If I perform a "find" it finds both cells, but
yet returns nothing. If I then copy the cell from tab one to tab two (they
both look like the same data) and paste, then it retuns with the result. I
have tried reformatting both columns and performed text to columns with no
change. Any suggestions?

Thank You,

Shazam
 
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
Match Columns Not Working - Formatting? Toppers Excel Discussion (Misc queries) 0 March 28th 07 12:13 AM
MATCH not working David Excel Worksheet Functions 5 February 12th 07 11:23 PM
Vlookup with Match Not Working Paige Excel Worksheet Functions 4 December 12th 06 07:52 PM
help with sorting text in columns to match other columns rkat Excel Discussion (Misc queries) 1 August 11th 06 03:42 AM
Index/Match not working frosterrj Excel Worksheet Functions 6 May 22nd 06 06:18 PM


All times are GMT +1. The time now is 09:50 AM.

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"