Showing the text in a cell that is in the same row another cell

  • Thread starter Thread starter Emma Todd
  • Start date Start date
E

Emma Todd

I have a spreadsheet that contains a column of Estate
Agent names and a column that says how many properties (%)
on their database have full postcode.

In this s/sheet I also have a formula which tells me the
maximum % of full postcode.

However, I would like, if possible, a formula to match the
result in with the Estate Agents name. E.g if Alan Ayers
had 100% (maximum %) then I would want to display their
name. How can I do this as they are in another column to
the result?
 
Hi
use VLOOKUP or INDEX/MATCH for this
e.g. column B stores your percentages, column A your names and in cell
C1 is a formula like
=MAX(B:B)

then use the following formula
=INDEX(A1:A100,MATCH(C1,B1:B100,0))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove certain characters from a text string 6
How to count the maximum number flanked by zeros 9
Retreive data for same agent 3
locate data from a chart by inserting data into a cell 3
Returning Multiple values 3
Return a name in the same row 3
I want to copy one cell value from sheet 1 to sheet 2 conditionall 2
Find and TRansfer from another Tab in same Worksheet 3

Back
Top