Look Up Value Question

[hotcomper]

Good morning, first post so go easy please. I think this is straight forward but I have struggled with a Google search. I have 2 x worksheets, ind Stab is sorted, what I want in Hidden teams is: when I select C3 there will be a drop down list 1-16, if you select 1 this will then reference to "ind Stab" worksheet and insert "David" in D3 of "Hidden Teams" and also insert "ind Stab" G3 in "Hidden Teams" G3. Basically Hidden Teams worksheet is used to select the teams using a drop number reference then autofills the name & total score. Thanks in advance.

[samba_ravi]

Welcome to the forum

D3=IFERROR(VLOOKUP($C3,'ind Stab'!$B$3:$G$18,2,0),"")
E3=IFERROR(VLOOKUP($C3,'ind Stab'!$B$3:$G$18,6,0),"")
Try the above and copy towards down

[hotcomper]

That has worked, thanks very much.

[samba_ravi]

you are welcome