Lookup help! How to return a specific line of text when return value is blank

[Noswen869]

Hello!

I am using a very simple lookup at the moment (=vlookup(a3&"*",Sheet1A:AZ,10,0). This works however when the cell it is looking at is blank it returns a 0 which is extremely misleading for the data set I'm using.

I'd like to know 1) How to just return a blank in this scenario - which I assume will be some form of IF/IFERROR but 2) more useful would be a formula which, when the return value is blank, it returns a line of text which says 'No Data Yet'.

I've found stuff online regarding Xlookups but that only seems to be useful when the value cannot be found at all. I'm finding what I want but I don't want it to return a 0 when it is blank

Any help would be much appreciated

 

[hagia_sofia]

Wrap up your look up formula into something like: IF(ISBLANK(vlookup(a3&"*",Sheet1A:AZ,10,0)),"No data yet",vlookup(a3&"*",Sheet1A:AZ,10,0).

 

[Noswen869]

Wrap up your look up formula into something like: IF(ISBLANK(vlookup(a3&"*",Sheet1A:AZ,10,0)),"No data yet",vlookup(a3&"*",Sheet1A:AZ,10,0).

This works! Thank you so much!