Excel

[Sanndeep chalke]

Hi,

Please solve this query i want to only apply vlookup of when starting number of 80 and remaining number show as NA.


Example

8097914598 1233
9800001223 NA
8096542545 6398
9812121123 NA
8063545445 1213

 

[Finalfight40]

Would something like this work?

=IF(AND(LEFT(A1, 2)=80, RIGHT(A1, 2)="NA"), VLOOKUP(,,,), "")

 

[Finalfight40]

Would something like this work?

=IF(AND(LEFT(A1, 2)=80, RIGHT(A1, 2)="NA"), VLOOKUP(,,,), "")

My bad, try this 1:

=IFERROR(VLOOKUP(IF(AND(LEFT(A1, 2)="80", RIGHT(A1, 2)="NA"), A1, ""), *ARRAY HERE*, FALSE), "")

 

[stumac]

Something like:

=IF(LEFT(A2,2)="80",VLOOKUP(A2,[COLOR=#0000FF][I]Range[/I][/COLOR],[COLOR=#FF0000][I]column[/I][/COLOR],False),"NA")