Match mobile numbers to people in a list ordered chronologically

Question

I have an sorted 'customer' sheet, containing the customer's ID number and their mobile number next to that, from #1 to #10. These customers orders/visits are to be listed in another sheet, in chronological order. I am trying to get the customer's mobile number by simply putting in their ID, and possibly add details once I get it working.

Is there a way that I am able to get the value of a customer's cell, variant on the customer ID number entered?

Logically as a Java developer, I have tried doing '=(Customers!B(A4)), but that doesn't seem to work. Basically, I need to set a value to the cell of B(customer ID number) in sheet customer, how would I go about this?

Answer 1

I would suggest VLOOKUP, partly because you don't seem to have too many variables:

Note that this will not work if columns A and B are switched over in customer sheet.

Answer 2

You could try combining INDIRECT, ADDRESS, and CELL:

=INDIRECT(ADDRESS(CELL("row", reference_cell), column_number))

So, instead of this:

'=(Customers!B(A4))

try this (column B is the 2nd column):

=INDIRECT(ADDRESS(CELL("row", $A4), 2))