Aug 10 2020 01:51 AM
Aug 10 2020 02:08 AM
=IFERROR(VLOOKUP(A2, C:D, 2, FALSE), "NO-REC")
Aug 10 2020 02:20 AM
As far as I have understood the problem definition correctly or have translated it, these formulas could help you.
This can be used to suppress the error message
ISNA(VLOOKUP($A$2,$C:$D,2,FALSE))
with this formula your desired text should be appear
=IF(ISERROR(VLOOKUP(A$2,$C:$D,2,0))," NO-REC",VLOOKUP(A$2,$C:$D,2,0))
* Provided that I have correctly translated the formulas into English.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
* Beware of scammers posting fake support numbers here.
Aug 10 2020 04:07 AM
Aug 10 2020 04:21 AM
Aug 12 2020 02:00 AM
@NikolinoDE Please find the sample file
Aug 12 2020 02:24 AM
Can it help you like this?
Is with conditional formatting.
If it doesn't help, please give us a short feedback.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
* Beware of scammers posting fake support numbers here.
Aug 12 2020 02:53 AM
Select the area with the left mouse button pressed.
Start menu
Conditional formatting
New rule
Format only cells that contain
First dropdown (from left to right) menu
selection: error
(all other dropdowns will disappear)
Press Format
font
Select color white (click)
OK
and press OK again
done ... the magic :)
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
* Beware of scammers posting fake support numbers here.
Aug 12 2020 03:01 AM
Aug 12 2020 04:20 AM
=IFERROR(LOOKUP(9,1/(D2:D10=H4)/(E2:E10=I4),F2:F10),IF(ISTEXT(H4),H4,I4))
Precondition, that all cells are formatted / set to "Standard".
Here is an example file with the choco ... is also my weakness...hahaha
If you find this helpful, please mark it as "Best Answer" and as Like (click thumbs up), it will be beneficial to more Community members reading here.
Nikolino
I know I don't know anything (Socrates)
Aug 12 2020 04:46 AM
Downloaded a text file in this direction from a German website.
Is really a good example.
The third-party products that this article discusses are manufactured by companies that are independent of me. I makes no warranty, implied or otherwise, about the performance or reliability of these products.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
* Beware of scammers posting fake support numbers here.