Formulae Help, should be easy...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi! I need a formula to look at the left 2 digits of a number in a given
cell. If the number shows "61" it is to return "AU", if it is "62" it is to
return "NZ". If it is blank it should show "".

Is anyone able to help me with this? Thx
 
Another suggestion:

=IF(A1="","",LOOKUP(--LEFT(A1,2),{0,61,62},{"","AU","NZ",""}))

numbers below 61 and above 62 return "", modify if needed.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
How to set the formula? 4
#DIV error 2
Lookup returning wrong results 0
How to set the formula - part 2? 17
Should be easy how to 1
Formula help 5
Use & with two formulas 2

Back
Top