vlookup in conditional formatting to to highlight percentage Ranges

[Sd100]

I am trying to use vlookup to conditional formate a cell based on the vlookup returned percentage value range of a another cell.
I have the formula=AND(>25%,<=50%),vlookup(a1,g4:g500,2,False) and am getting no results. I have tried variations but none have been successful so far. Any advice?

[Tony Valko]

vlookup(a1,g4:g500,2,False)

The table_array in the VLOOKUP only has 1 column in it yet you're using 2 as the col_index_num. You either have to use 1 as the col_index_num or expand the table_array to include more columns.

Based on your formula here's what I think you're trying to do:

=AND(VLOOKUP>25%,VLOOKUP<=50%)

Is that close?

[Sd100]

Sorry, I miss typed on the Table_array it should have been ag4:i500.
I am trying to use vlookup to conditional formate a cell based on the vlookup returned percentage value range of a another cell.
I have the formula=AND(>25%,<=50%),vlookup(a1,g4:I500,2,False) and am getting no results. I have tried variations but none have been successful so far. Any advice?

[Tony Valko]

Is this what you're trying to do:

=AND(VLOOKUP(A1,G4:H500,2,0)>25%,VLOOKUP(A1,G4:H500,2,0)<=50%)

[Sd100]

Yes ,that works thanks for the help!

[Tony Valko]

You're welcome. Thanks for the feedback!