Notifications
Clear all
Topic starter
How do I write a formula to tell excel to lookup values in different tables, depending on what a specific cell says.....for example, If A1="M", Index B3:E10, and match on certain criteria, if A1="F", Index F3:I10, and match on same criteria? So, basically, if the person is male, I want excel to look up scores in a specific table, if that person is female, I want excel to use a different table of data.
Posted : 27/01/2018 5:10 pm
Hi Lynn
You can try this
=IF(A1="M",Index B3,F10 etc, Index F3:I10 etc)
Replace the text in blue for Male and red for Female for what you want to do.
Hope this helps
Sunny
Posted : 27/01/2018 7:28 pm
