Look at data in 2 columns to give result in 3rd column

[dgraham1962]

Hi All,

In sheet1 i have 4 columns and 57 rows.

in sheet2 i have data in columns C, D & E

what i need to do is have a formula in sheet1 example: D5 to look at sheet2 Column C AND D and if true enter E.

ie.. D5 is 0&1, C5 is 0&2, B5 is 0&3 and A5 is 0&4 (these are locations in the 1st image) so i look at sheet2 and if there are true values in columns C & D then enter column E.

formula in D5 would need the results in sheet1 to be C=0 and D=1 if true enter 470

hope this makes sense.

Regards
David

 

[Jamie McMillan]

Hello David,

In D5 paste the following

=IF(AND(Sheet2!C1=0,Sheet2!D1=1)=TRUE,Sheet2!E1,"")

If true it returns E1 value, if not it will be an empty cell.

Hope that is what you wanted.

Jamie