Hi all

I am wanting a formula to do 2 thing for the one cell

I need it to look up in column "f" on a page called current the highest
number in this column

I know to use the max formula but I then need it to show the corresponding
rows item in column b

I am not sure how to do this?

Thanks

Greg