A
andrew
Hi,
My spreadsheet grabs data through web query to display the following table:
16/5 Engine Nut 22.5 11.2 32.5
16/5 Exhaust SCREW 33.1 5.8 12.3
16/5 Radiator Bolt 14.6 12.2 23.2
21/5 Screw ENGINE 8.6 11.4 21.8
21/5 NUT Bolt 26.5 17.9 11.4
21/5 Exhaust Radiator 9.2 12.5 18.8
How do i formulate in a different sheet ('Summary' sheet) cell to check if:
1) A = 16/5 (date), then look for word "Engine" in B1:C6
2) if "Engine" is in B then display value/data from D1
Another scenario (different cell in 'Summary' sheet) is where if:
1) A = 16/5 (date), then look for word "Engine" in B1:C6,
2) if "Engine" is in B then display values from D1:F1 in the formula cell
for D1, then E1 in the next cell of the formula cell, and F1 in the cell
after. Possible?
Note: The web query returns the table with space in front of the text
sometimes, or capital text at other times (dunno why...). I would assume that
wildcard is required to search for matching text?
My spreadsheet grabs data through web query to display the following table:
16/5 Engine Nut 22.5 11.2 32.5
16/5 Exhaust SCREW 33.1 5.8 12.3
16/5 Radiator Bolt 14.6 12.2 23.2
21/5 Screw ENGINE 8.6 11.4 21.8
21/5 NUT Bolt 26.5 17.9 11.4
21/5 Exhaust Radiator 9.2 12.5 18.8
How do i formulate in a different sheet ('Summary' sheet) cell to check if:
1) A = 16/5 (date), then look for word "Engine" in B1:C6
2) if "Engine" is in B then display value/data from D1
Another scenario (different cell in 'Summary' sheet) is where if:
1) A = 16/5 (date), then look for word "Engine" in B1:C6,
2) if "Engine" is in B then display values from D1:F1 in the formula cell
for D1, then E1 in the next cell of the formula cell, and F1 in the cell
after. Possible?
Note: The web query returns the table with space in front of the text
sometimes, or capital text at other times (dunno why...). I would assume that
wildcard is required to search for matching text?