ok i have used vlookup and its like

=VLOOKUP(B26,B2:AF23,B2:AF2,FALSE)

where B26 refers to a value and its ok

but Table_array shows an error that its referring to an empty cell when
that cell contains data not functions but data.. and i need it to show me the
data in that cell, but i dont know what to specify.. plz help

exactly i need to know an another value from the same row and when i looked
up help i founf vlookup does it but i cant do it..

i'll explain in detail,

i wish to see the max value from a row and then in another cell i wish to
see an another value from the column of the result of max value.

for eg: B26 has function =MAX(B23:AF23) and it results 1157 (1157 is on P23)
then in B27 i wish to see the data from column P2 from the same column of
the results of b26

so i input =VLOOKUP(B26,B2:AF23,B2:AF2,FALSE) in B27

hope am clear and am i using the right function to view the data from the
same column refering to B26