Vlookup for Specific text

[Sri.n]

Hello,

Could any one help me in vlookup function which has to give me an output of specifi text

Attached is the example

Thank You

[Fotis1991]

Try

=INDEX($B$1:$B$10,MATCH(F1,$A$1:$A$10,0))

[Sri.n]

Sorry Fotis its giving me all the values but I am looking just "A" as my output

[Palmetto]

You need to use absolute references in your formula

You have: =VLOOKUP(F1,A1:B10,2,0)

You need: =VLOOKUP(F1,$A$1:$B$10,2,0)

Copy the formula down the column and the references to the source range will be preserved

[Fotis1991]

Try

=IF(VLOOKUP(F1,$A$1:$B$10,2,0)="a",VLOOKUP(F1,$A$1:$B$10,2,0),"")

[Sri.n]

Yeah.. this is working file.. Thanks a lot for yor help Fortis

[Fotis1991]

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

[oeldere]

Another possible solution.

Please Login or Register  to view this content.