D
DanFox
I have a spreadsheet:
I don't fully understand lookup formula, particularly in cases such as
this, where i need to copy data from more than one cell.
Worksheet 2
A B C D
1 Date Item Price Total
2 1st Apr Widget £1 £3
3 2nd Apr Brush £2 £2
4 3rd Apr Brush £2 £0
5 4th Apr Widget £1 £5
I would like to create a formula in worksheet 1 that returns the data
held in columns A, B, C and D of worksheet 2 - but only where the
value in D is greater than 0.
If the formula works, worksheet 1 should appear as:
A B C D
1 Date Item Price Total
2 1st Apr Widget £1 £3
3 2nd Apr Brush £2 £2
4 4th Apr Widget £1 £5
I know I need some kind of lookup statement, but can someone help by telling me what the formula needs to be?
I don't fully understand lookup formula, particularly in cases such as
this, where i need to copy data from more than one cell.