Hey knowledge well. I've been experimenting with vlookup/hlookups and not really getting far. Just looking for some advice please.

If I have a bunch of order numbers in one sheet, called "orders" and there's no heading, it's simply at A1 an order number exists, of say "P1988", and then another one at A2 "P2042" so on and so forth ...

How do I use that list of order numbers to then go and search across another sheet (in the same spreadsheet) called, "timesheets" to do the following.

Using cell A1 in "orders" lookup that number in column B of "timesheets" (ignoring the first 10 rows) from row 11 down, and when that order number is found, search down in the same column B until you find the word "subtotal", when "Subtotal" is found, move right 11 columns and when you land on that value in column M, copy the value in that cell back to the "orders" sheet in cell B1

so on and so forth, until the end of the list is reached in orders with a corresponding value.

Thanks all, appreciate any pointers.