Thank you so much Isabelle and Mick for your super answers. The table
and it's lookups are working like a champ.

Pete
On Jan 25, 9:10*pm, Vacuum Sealed wrote:
On 26/01/2012 5:01 AM, isabelle wrote: hi Pete,

you can added to the table a new row
with in column A formula - =""
and in column B formula - ="" (or text ---)

Hi Pete

You need to convert your extracted value to a number so change your
formula to this:

[B2]=VALUE(IF($A2="","",MID($A2,10,1)))
[C2]=VALUE(IF($A2="","",MID($A2,11,1)))

With the helper columns in mind I did the following ( change Sheet
Names, Columns & Ranges to suit)

I placed the below formulas in Columns L & M to extract the value from
the array.

[L2]=IF(B2="","",LOOKUP(B2,myLookups!$A$2:$B$10,myLook ups!$B$2:$B$10))
[M2]=IF(C2="","",LOOKUP(C2,myLookups!$A$2:$B$10,myLook ups!$B$2:$B$10))

And finally, in Column D, I placed the following to constenate the 2 values:

=L2 &"/"& M2

HTH
Mick.