Hi,
the natch is a good way, but here jus another for fun!

insert a blank col in the lookup array, then fill it with the
corrsponding row number, then re turn this as the look up vale, and if
you like co0cTONATE IWTH WITH the col letterthus
A B C
1 vlookup 23 1
2 " 243 2
3 "..etc
4

="C"&(vlookup(23,B2:c4,2,1)) ... somthing like this,i havn't put it
thjough excel...
this might be good if you have loads of look ups runnning down a
colum, it might save memory by reducing the formula size... but the
match method is a lot smarter!

good luck
ross