Multiple function to link with Vlookup error

[Toothie]

Im trying to form some formula for the scenario.

1) If Cell = Text, Then VLOOKUP , Else Show Empty
2) If Cell A = Text , Then Cell B = Text , Else Show Empty

Much help is appreciated

[samba_ravi]

I6=(G6+H6)*ISERROR(F6+0)
K6=IF(ISTEXT(F6),F6,"")
L6=IF(LEN(K6),VLOOKUP(I6,N$6:P$16,3),"")
Try this and drag towards down

[Toothie]

Thanks ..
What is the usage of the LENGTH ?
Is it something like string character to key into the excel ?

I6=(G6+H6)*ISERROR(F6+0)
This formula , what is the elaboration on this ?



It works in the spreadsheet !!