VLOOKUP Returning 0 value

bobgrand

Board Regular
Joined
Apr 14, 2008
Messages
244
Office Version
  1. 365
Platform
  1. Windows
Hello all,

I am using a simple vlookup and never came across this one. The formula is returning data from another tab but if there there is no data to return and the cell is blank I would expect the result to be blank and not 0.

Any help would be greatly appreciated.

Bob
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
That is standard behaviour when the value is found, but the return is blank.
Are the return values text or numbers?
 
Upvote 0
1605031369933.png

The Vendor Transmission column is returning a 0 where that 0 should be blank.

The data in Sheet2 is raw text from our system.

=VLOOKUP(C3,Sheet2!$C$3:$E$3500,3,FALSE)
 
Upvote 0
In that case try
Excel Formula:
=T(VLOOKUP(C3,Sheet2!$C$3:$E$3500,3,FALSE))
 
Upvote 0
Thanks Fluff, That didn't work. Notice the word "EMAIL" disappeared.

1605032487657.png
 
Upvote 0
It returns text if given a text value or an empty string if given anything else.
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,988
Members
448,538
Latest member
alex78

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
Back
Top