Create the Sea Battle game in a Excel sheet

  • Thread starter Thread starter Guest
  • Start date Start date
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:
 
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
 

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

Back
Top