Correction in function

[Karnik]

Hi Experts,
When following function is used for matching , it gives blank result in column D

IF(ISNUMBER(MATCH(($C$2:$C$11),A2:B2,0)),C2,"")

( Col D numbers are written manually and above function to give results after correction....
Sample file attached


A B C D

2 4 1
1 2 3 1
6 8 5
7 20 7 7
6 14 9 14
11 13 10
8 21 12
26 28 14
11 16 16 16
18


Thanks
Karnik

[avk]

Can you more describe in details, i don't understand logic.

[jme1013]

So, you're wanting column D to display matches from columns A,B,& C, from the same row?

I opened the sheet you attached and it's working just by inserting the formula you provided in column D.

[Karnik]

Hi
Thanks for addressing function
I have one set of fix numbers, if any one of this is matched,from given range of numbers, write in given cell , if not found, leaves blank
Please review excel file
Thanks in advance
Karnik

[AliGW]

This maybe:

=IFERROR(VLOOKUP(A2,$C$2:$C$11,1,0),"")&IFERROR(VLOOKUP(B2,$C$2:$C$11,1,0),"")

[Karnik]

Hi JME and AVK
You were right , it worked , I did not pay attention in details..... that may have confused both
Cheers
Karnik

[Karnik]

Hi Atul
Sorry to bother you again.
Please see proper attachment.
Can you please review my remarks ?

Thanks
Karnik

[protonLeah]

Please Login or Register  to view this content.

[Karnik]

Hi Ben,
Thanks, it works without any bugs...
Cheers
Karnik

[protonLeah]

................