ROW number corresponding to a data

**santhosh kumar** · 12-29-2008, 11:41 PM

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** · 12-29-2008, 11:59 PM

Can you upload you file?

**santhosh kumar** · 12-30-2008, 11:07 AM

Thanks for th ereply am attaching the file here

**martindwilson** · 12-30-2008, 11:26 AM

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

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

**santhosh kumar** · 01-01-2009, 08:48 AM

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