Finding cell references on two workbooks

[FullyFamous]

I’m looking for a formula (Or how to) to locate the same record that is on one workbook and show on another workbook.

On workbook one, I enter a customer by the Customer (ID) Number.

On workbook two, I have customer numbers saved in columns.

I am looking to have it so that when I enter a customer number on WB1 in my ID number column, it will find that same number on WB2, .
And, if that can be accomplished, I now want the cell number found on WB2 to show on WB2 as a number that represents B3.


Hope this isn’t too complicated to make out.

 

[Ken Cowen]

I think it might be too complicated. What does it mean to have "customer numbers in columns"? Does that mean they are in a row? If you enter something on WB1 and it can be found on WB2, then you want the "cell number" whatever that is (row number maybe?) to appear on WB2? Where on WB2? And what do you mean by a number that represents B3? What is B3?

If by chance your customer numbers are in a column (say A) on workbook 2 then you can use the following formula on workbook 1 to identify the row of the matching entry

=MATCH(A1,Sheet4!A:A,FALSE)

after that I am not sure what needs to happen.