ROW number corresponding to a data

[santhosh kumar]

I have two problems

1. In column A i have diffeerent values in random order (not in ascending or descending order) i want to display the row number of a pirticular cell value ?

2. I have column A and B has values in random order not in any order as above ,i want to search and display for the maximum value in a range from column A and the corresponding value (same row) in column B ?

thanks in advance

santhosh

[solomon2211]

Can you upload you file?

[santhosh kumar]

Thanks for th ereply am attaching the file here

[martindwilson]

for your example
=MATCH(20,B7:B16,0)+6

and
=VLOOKUP(MAX(B7:B16),B7:C16,2,FALSE)

[santhosh kumar]

hi,
Thanks for the replay ..the second one worked for me but the first one, if i inserted one row above that data, i must change my equation again, is there any direct function to get the row number of a pirticular data ?
thanks again
santhosh

[Andy Pope]

try this mod to Martin's formula

=MATCH(20,B7:B16,0)+(ROW(B7)-1)

[santhosh kumar]

hi,
thanks it worked for me, thanks again a lot for both replys.
santhosh