Create the Sea Battle game in a Excel sheet

R

RomeuSilveira

Thks for your answer!
I posted this question because what I need is something similar from this.
More specified...I need to know if it is possible to do in the Excel a form
that combines the "vlookup" and the "hlookup". Ex. Imagine One sheet that has
some cods on the colums and another cods on the ligns, and in another sheet
with the a summary of the information I want, with the cods in diferent
places.


"Sandy Mann" escreveu:
 
P

Peo Sjoblom

No but you can use INDEX and MATCH


=INDEX(A1:F100,MATCH(x,A1:A100,0),MATCH(y,A1:F1,0))


adapt to fit your own table range, criteria and requirements
 
Top