Execute VLOOKUP is ANY value exists in another cell......

[ec1957]

Have done a ton of searching, can't find the answer to this. I simply want a cell to execute a VLOOKUP if ANY value exists in another cell.

As an example, E2 executes a vlookup on C2 if any value exists A2. If no value exists in A2, then E2 is blank.

Thanks everyone, I'm guessing I just have a brain lock but can't figure this baby out, take care.

 

[Fluff]

Can you please explain what you mean by

E2 executes a vlookup on C2

 

[ec1957]

Sure; let's say that in column E2 there is a vlookup that looks in another sheets table based on the value in C2 - however, if there is no value at all in A2, then don't execute, keep it blank. But if there is a value in A2, then go ahead and execute the vlookup.

 

[Fluff]

Ok how about

=IF(a2="","",vlookup(C2......))

 

[ec1957]

Good lord I feel like an idiot - Thank You.

 

[Fluff]

Glad to help & thanks for the feedback.