Vlookup/match?
On Aug 29, 1:22*am, "Max" wrote:
"Chris" wrote
It gave me a NA
Then I suspect that your JobCode data is inconsistent
Here's some options to the earlier to improve robustness in matching
If its text, try in G2:
=INDEX(Sheet2!E:E,MATCH(TRIM(C2),Sheet2!A:A,0))
TRIM removes extraneous spaces
If its numbers, try one of these options in G2:
=INDEX(Sheet2!E:E,MATCH(C2+0,Sheet2!A:A,0))
+0 converts text numbers to real numbers
=INDEX(Sheet2!E:E,MATCH(C2&"",Sheet2!A:A,0))
&"" converts real numbers to text numbers
=INDEX(Sheet2!E:E,MATCH(Text(C2,"000000"),Sheet2!A :A,0))
TEXT converts real numbers to text numbers, padding leading zeros to 6
digits (adapt to suit)
--
Max
Singaporehttp://savefile.com/projects/236895
Downloads:17,500, Files:358, Subscribers:55
xdemechanik
--- *
Yes, you are right. I got it to work after a while, thanks for the
extra tips and for your help.
|