VLOOKUP but not exactly

[Infine]

Hello,

I want to do a VLOOKUP on my master, then look for it in Sheet1 and if it finds it I want it to look at the columns next to it and then tell me if it is empty = "No data", if it has a value = "There is something here".
So I am not interested in the first VLOOKUP, but necessary to be able to locate the columns next to it. And I am not interested in VLOOKUP it, I just want to return another value such as "There is something here" or as stated below.

=IF(ISNA(VLOOKUP(A196;'Sheet1'!$P$6:$U$1048576;6;FALSE));"No rebate";"Rebate in %")

So this is my current code but I noticed the issue is that it is looking up the first column. I am more interesting in the "6" but to go there I need to do VLOOKUP.

Anyone knows what to use for code instead? Or is the code above correct? If I VLOOKUP it return "0" if it is empty, which is why it not working properly? I want it to return "No rebate" if it is empty basically.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Infine]

Version 2209 it says

 

[Fluff]

That is the build version, The version of Office will be something like 2019, 2021 or 365

 

[Infine]

It says Microsoft 365 Apps for enterprise

 

[Fluff]

That's the one, please update your profile to show that.

How about

=let(v;VLOOKUP(A196;'Sheet1'!$P$6:$U$1048576;6;FALSE);IF(ISNA(v);"Not found";IF(v="";"No rebate";"Rebate in %")))

 

[Infine]

That's the one, please update your profile to show that.

How about

=let(v;VLOOKUP(A196;'Sheet1'!$P$6:$U$1048576;6;FALSE);IF(ISNA(v);"Not found";IF(v="";"No rebate";"Rebate in %")))

Thanks! It looks like it works! Learned something new as well!

 

[Fluff]

You're welcome & thanks for the feedback.