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

ec1957

New Member
Joined
Jul 29, 2008
Messages
31
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.
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

ec1957

New Member
Joined
Jul 29, 2008
Messages
31
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,794
Office Version
  1. 365
Platform
  1. Windows
Ok how about
Excel Formula:
=IF(a2="","",vlookup(C2......))
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,794
Office Version
  1. 365
Platform
  1. Windows
Glad to help & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,128,122
Messages
5,628,824
Members
416,342
Latest member
BlueDevil12

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top