if function
"Gord Dibben" wrote:
Enter in B1
=LOOKUP(A1,{511,512,513,514},{"anil","sunil","amit ","ritesh"})
Gord Dibben MS Excel MVP
On Tue, 21 Apr 2009 23:54:01 -0700, hitesh
wrote:
dear
if i type 511 in cell A1 then in cell B1 there will be anil,if i type 512 in
cell A1 then in cell B1 there will be sunil. if i type 513 in cell A1 then in
cell B1 there will be amit. if i type 514 in cell A1 then in cell B1 there
will be ritesh.
is there any formula for this.
pls help
thanks a lot
|