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.