I have one sheet with a list of fruit then next 6 colums are marked week1 to 6
Fruit Week1 Week2...
Apple 23 45
oranges 10
pears 5 6 7
on a second sheet I want to lookup the fruit and bring back the last row with data in it
if I lookup apples it will return 45
oranges 10
can anyone help
Fruit Week1 Week2...
Apple 23 45
oranges 10
pears 5 6 7
on a second sheet I want to lookup the fruit and bring back the last row with data in it
if I lookup apples it will return 45
oranges 10
can anyone help