Try this:

=INDEX(B2:AF2,MATCH(B26,B23:AF23,0))

--
Biff
Microsoft Excel MVP


"SunnyWantsome" wrote in message
...
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