Need to use a Vlookup to make my sheet fill in the table

[slock92]

Hey guys,

Kind of hard to explain, basically im trying to find the formula to make this table

Test 2.PNG

Completed automatically without me needing to do anything from these results, I write in the blue boxes only and the last column has a rank formula in
Test 1.PNG

at the moment I Have made it so I can if i type the athletes number in the No. Box it will come up with their name, club and distance but they must be a way to do this automatically with a formula linking their final position column?

[RedSummer]

Could you post your sheet? This looks like a VLOOKUP problem but I'm not following where you keep your information or which table you want the formulas for.

[FDibbins]

Hi slock92, welcome to the forum



Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[slock92]

deleted post

[Pete_UK]

You have attached pictures of your file, but they are of no use to work on - attach a sample Excel workbook instead.

Pete

[adhawan06]

Hi slock92,

Could you attach the file here so that it will be very easy for all of us to respond on your query.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

Attach A File.jpg

[slock92]

Here is the workbook

[FDibbins]

It would help if you included some dummy data ans showed what your expected answer looked like?

[slock92]

sheet attached please see sheet U15 Girls Shot Putt

[FDibbins]

Try this instead...
=INDEX(C$6:C$25,MATCH($A28,$O$6:$O$25,0))
copied down and across for 1-10
for the "score", change the reference

For 11-20, you will need to change the bolded part as well, before copying down

[slock92]

Brilliant Thank you very much

[FDibbins]

Happy to help

[slock92]

Try this instead...
=INDEX(C$6:C$25,MATCH($A28,$O$6:$O$25,0))
copied down and across for 1-10
for the "score", change the reference

For 11-20, you will need to change the bolded part as well, before copying down

Ive used this formula it works but just because im a bit of a perfectionist, is they a away to remove the #N/A? it works when the data is in but before the data is in can i remove the #N/A??

Cheers
Steve

[FDibbins]

sure...
=iferror(iNDEX(C$6:C$25,MATCH($A28,$O$6:$O$25,0)),"")

[slock92]

sure...
=iferror(iNDEX(C$6:C$25,MATCH($A28,$O$6:$O$25,0)),"")

Brilliant :D

Thank you that is great, I am making a results programme for an event and that is a big help, I may need your help further on in the programme, if that is ok

[FDibbins]

Look forward to helping you again