What’s my Best way to return a data value – 

Hello what’s my best way to return a value based on multiple criteria? 

X lookup or Index/Match ?

I have the sample data sheets below 

I need Column ‘R’ in ‘sample data master’ to look at column ‘g’ and column  ‘d’ in  ‘sample data master’ and look into ‘Sample data 1 lookup’ against column ‘d’ and ‘e’ and return column ‘h’ in  ‘Sample data 1 lookup’

Happy to use any formula that does this – so just asking for help 

​What’s my Best way to return a data value –  Hello what’s my best way to return a value based on multiple criteria?  X lookup or Index/Match ? I have the sample data sheets below I need Column ‘R’ in ‘sample data master’ to look at column ‘g’ and column  ‘d’ in  ‘sample data master’ and look into ‘Sample data 1 lookup’ against column ‘d’ and ‘e’ and return column ‘h’ in  ‘Sample data 1 lookup’ Happy to use any formula that does this – so just asking for help   Read More

​