Pete, When I place the formula and try to copy into the cell belowA4 the
values of M1:N5 change within the formula so the more I put in the table more
gets missed out as I copy the formula into the sheet, any ideas.
--
Tim


"Pete_UK" wrote:

You could build up a table, eg M1:N5 as follows:

Apple 2
Banana 4
Grape 7
Orange 5
Pear 3

Then in A5 enter:

=IF(A3="","",VLOOKUP(A3,M1:N5,2,0))

Hope this helps.

Pete

On Jul 6, 2:22 pm, Tim wrote:
I have a cell ie. A3 which is a word and I want to tell cell A5 that whenever
it sees this word to asign it a value of 5 foe example.

Orange=3

Is this possible
--
Tim