Show the value from the tables with two dependencies.

Hey. I'm sorry if the title is not precise. I really don't know how should I call things which I searching for...

I have form like: Width and Size. User needs to fill in width like 100;200;300, etc and size like 1; 1,5; 2; 2,5...

I have tables like this:

size\width	100	200	300	400
1	22	33	44	55
1,5	66	77	88	99
2	AA	BB	CC	DD
2,5	EE	FF	GG	HH

User want Width 200 and Size 1,5. What to do to show Value 77 in the result table? My all knowledge about excel are simple functions like if, and, or, not, etc. But the problem is my tables are much bigger... So writing functions like that isn't an option...

Thanks for help!

Originally Posted by cubangt

can you provide a sample workbook with some test data to work from?

As a user, what will i be completing to get my result? a form? a row within a worksheet?

File in attachment.

It works great! Thank you! I wait for an email with a reply notification but it never came.

Still two questions...
1. If I make my table bigger - do I need to change something else? In the original file, there was something like this vlookup for some calculations. But when I changed positions on some lines it stops working... I added extra spatie 55 in your file, under existing tables with random numbers and unfortunately, I get also #N/A.

2. Can I change #N/A to something else? Like question mark.

Thank you one more t

Thank you!!!!!

Just last question...

For sheet SA and SB you selected B2:N21. But the table use max I21. Is it because other tables using N21 or you just copied it to show me how it works?

Okay. Thank you one more time!!!!