cross referancing

[MarcLewis]

Sorry if this is in the wrong section, i am trying to have cell f10 = the cross reference d10 & e10 (Note d10 & e10 validation dropdown lists)
D10 = h.264, mjpeg, mpeg4 & raw
e10 = qvga, sif ntsc, cif etc

can somebody pleae help


2.jpg

[JBeaucaire]

As per forum rules (read them at the link above in the blue bar), post a sample workbook, not a picture.

In your posted sample workbook, be sure to manually mockup the desired results and point out the cells you did manually that you want to automate. Use BEFORE/AFTER sheets if necessary to make it clear.

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.

[MarcLewis]

Apologies for not uploading example worksheets please findattached copies of my worksheet
Many Thanks.


After.xlsxBefore.xlsx

[JBeaucaire]

For this to work, the indexed values in column E must match the data table.

1) change the data validation List source in column E to N3:N20
2) edit the one value E10 so it says QVGA (from the new list source)
3) put this formula in F10 and copy down:

=IF(COUNTA(D10:E10)=2, INDEX($P$3:$S$20, MATCH(E10,$N$3:$N$20,0), MATCH(D10,$P$2:$S$2,0)), "")

[MarcLewis]

Rec Server Capacity Calculator V3.xlsx


Thank you so much you are an Excel God, unfortunatley my boss has now requested that the value of F10:F30 be dependant on the value of G10:G30 (2X Values already in a dropdown list 25 & 30) using the first table O3:R3 TO O20:R20 for the value of 25 & the second table AB3:AE3 TO AB20:AE20 for the value of 30.
what alterations do i need to make to the formula you have so kindly provided.

Many Thanks.

[JBeaucaire]

1) I created "named ranges" out of the colored tables. The first is called Table25 and the second is called Table30
2) Since Frame size is now dependent on the FPS selection, I swapped those two columns. Required columns should always come first.
3) Then used basically the same formula, just added an INDIRECT() function to decide which of the two tables to INDEX

[MarcLewis]

Thank you i cant begin to show my gratitude

Thank You.