IF, VLOOKUP or something else?

[cruyff73]

I have 2 tables of data and want to create a search function for a colleague to display the specific data from the relevant table. I'm probably overthinking this (it's Friday after all!)

Easy to do if I just want to show details of one table using this:

=IF(AND($B$4="FR5",$B$5="Productivity",$B$6="August"),FR5PR!B318)

but what/how do I add to this if I wanted to say -

OR

=IF(AND($B$4="FR5",$B$5="Reject",$B$6="August"),FR5PR!B379)

Thanks in advance

 

[Aladin Akyurek]

Never describe a problem for which you seek a solution by means of Excel formulas instead of just words...

Perhaps something like:

=IF(AND($B$4="FR5",$B$6="August"),IF($B$5="Productivity",FRPR5!B318,IF($B$5="Reject",FRPR5!B379,"")),"")