Phil Payne
Board Regular
- Joined
- May 17, 2013
- Messages
- 131
- Office Version
- 365
- Platform
- Windows
Hello all,
I thought this would be straightforward but, no I keep getting "Not Found" when I can see a value?
Note the two columns of the GPR_Data worksheet B:B and F:F contain multiple instances of what I am looking for but if used together they will provide a unique reference.
I've tried these and more:
and this
Do I need to modify my formula or replace it?
Does it matter that the criteria are text and the result is currency?
I hope someone can guide me with this!
in english -
'If my,wksht.mycell.value (C6) can be found in other.wksht!columnB:B AND my,wksht.mycell.value (D6) is also to be found in other.wksht!columnF:F thenreturn the value found in other.wksht!column.EZ:EZ to mywksht.mycell (E6).
I thought this would be straightforward but, no I keep getting "Not Found" when I can see a value?
Note the two columns of the GPR_Data worksheet B:B and F:F contain multiple instances of what I am looking for but if used together they will provide a unique reference.
I've tried these and more:
Excel Formula:
=if(and(C6=GPR_Data!B:B,D6=GPR_Data!F:F),GPR_Data!EZ:EZ,"not found")
Excel Formula:
=if(and(GPR_Data!B:B=C6,GPR_Data!F:F=D6),GPR_Data!EZ:EZ,"not found")
Do I need to modify my formula or replace it?
Does it matter that the criteria are text and the result is currency?
I hope someone can guide me with this!
in english -
'If my,wksht.mycell.value (C6) can be found in other.wksht!columnB:B AND my,wksht.mycell.value (D6) is also to be found in other.wksht!columnF:F thenreturn the value found in other.wksht!column.EZ:EZ to mywksht.mycell (E6).