Extraxting data from database to a better lay-out

[Suehtomit]

Hello everybody,

I am busy trying to creatin a form, but I can't find what is the write formule to use.

My excel form exist out of 2 sheets. The first sheet contains a lot of data (both text or numbers), but it is in a format which is not easy to read, so on the second sheet I want to create a form where it will be possible to see part of the data in a more friendly form.

What I want is a dropdown menu within the names which refer to rows in the first sheet (e.g. Department A, Department B, Department C. etc.)

the rest of the sheet is a blanco form in wich the data could be presented in a clear overview. My question is which formule I should put in the cells ment for showing the data to show up the right information corresponding with the requested data?

I put an example which does what I want using the "If" formule, which is ok for limited data, but not for the amount of data I am planning to add to it.

Thanks for your help

[JBeaucaire]

This is a standard LOOKUP table scenario, like a mapping grid. I would use INDEX with MATCH to get the X and Y coordinates.

In cell C11, put this formula, then copy down:

=INDEX($C$2:$G$5, MATCH($G$10, Criteria, 0), MATCH($B11, $C$1:$G$1, 0))

[Suehtomit]

Thank you, I think I can translate this solution to my form :-)