Assign a number to a cell

**MATU70** · 10-09-2014, 07:33 AM

Hi

I am trying to assign a number to letters in a cell.
E.G
AB = 4
AC = 5
AD = 7
BT = 9

Lets say column A has the letters and i want column B to assign the number according to the letters.

Hope this is clear

**cobwebs** · 10-09-2014, 07:48 AM

Simple method might be Vlookup as per attached sample

**AlKey** · 10-09-2014, 09:09 AM

Try this

=IFERROR(LOOKUP(A1,{"AB",4;"AC",5;"AD",7;"BT",9}),"")

**MATU70** · 10-09-2014, 09:21 AM

Thank you very much its perfect

**AlKey** · 10-09-2014, 09:25 AM

You're welcome and thank you for the feedback!

Assign a number to a cell

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Assign a number to a cell

Re: Assign a number to a cell

Re: Assign a number to a cell

Re: Assign a number to a cell

Re: Assign a number to a cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Assign a sequential number IF a cell contains text

Assign a number in a cell to repersent certain days of the week in another cell.

[SOLVED] If cell is not blank, assign next number in sequence

Find a number in a column then assign another cell number for the output number

Assign a number to a value range in a specific cell?

Bookmarks

Bookmarks

Posting Permissions