Hello,
I trying to match numbers from workbook 1 to a Master workbook where as,
Workbook 1 has numbers that are 4 digits (0123, 0234, 0345, 2134,....8999)
and
The Master workbook numbers are 3-4 digits (123, 234, 345, 2134...8999.
What I was wondering if there is some way to add an If statement something to the effect of
"if first digit of the cell=0, then match the last 3 digits only.
P.S. The code works fine when both numbers are 4 digits.
I trying to match numbers from workbook 1 to a Master workbook where as,
Workbook 1 has numbers that are 4 digits (0123, 0234, 0345, 2134,....8999)
and
The Master workbook numbers are 3-4 digits (123, 234, 345, 2134...8999.
What I was wondering if there is some way to add an If statement something to the effect of
"if first digit of the cell=0, then match the last 3 digits only.
Code:
=INDEX('C:\Documents and Settings\Owner\Desktop\[master.xls]Numerical Data'!$E$5:$E$266,MATCH(D40,'C:\Documents and Settings\Owner\Desktop\[master.xls]Numerical Data'!$B$5:$B$266,0),1)
P.S. The code works fine when both numbers are 4 digits.