Return Text if Number Matches

[tlc53]

Hi,

I have been trying to figure out this formula for sometime and feel it's now time to call in the experts.

A2:A10 Account Code (format ### or ###/###)
B2:B10 Account Description (text)

B15 - This is a manual entry tab, you enter the account number
B16 = I want this cell to return the Account Description from B2:B10 depending on the account number entered above, in B15.

Thanks very much.

 

[tlc53]

Thanks. I see where you were getting at with that but it didn't fix the problem..

=IF('XPA Data Table'!B839="",TEXT('XPA Data Table'!A839,"000")&"",TEXT('XPA Data Table'!A839,"000")&"/"&TEXT('XPA Data Table'!B839,"000"))

I have managed to resolve this now by changing the format type to TEXT and amending the data validation associated to the data entry cell. Thank you!