Hi,
I'm trying to match a value(Column1) to another value from a range (Column2) and display a value from (Column3).
It does not display a value, but #NA.
However, when i manually type the data on Column1, it will display a value from Column 3, if it matches column 2.
Tried all sorts of cell formatting, but it still does not work. Basically, the copied and pasted data does not read.
Appreciate your help on this.
formula looks like this:
=INDEX($K$2:$K$742,MATCH(A2,$J$2:$J$742,0))
Hi,
Your lookup value and the values in your lookup array need to be the same data types so it will not work if, for example, one is text and the other numeric. Formatting the cell does nothing to change the underlying value so will make no difference.
It might help to see a sample workbook showing the data you are working with.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Hi
It's look's like a format problem. Take a look on it....However, when i manually type the data on Column1,
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
How do I change the underlying format if by formatting cell is not gonna help?
Tks for looking.
It depends what values we're talking about. Can you upload a sample workbook?
Dom
Hihi.
Found the problem. There were spaces after the copied and pasted data.
How careless of me.
Tks for the help ppl.
Appreciate it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks