what formula do i use to find a number in a different column that.

[Guest]

In excel (spreadsheet A) i have a column F with numbers from 35,000 to 59,000
sometimes these are not in order or can be repeated.
In another sreadsheet (B) I have numbers from 35,000 to 59,000, in order in
column D, and a code in the same row in the next column.
If the number in (Spreadsheet A) is 38005 i want a formula to find that
number in (Spreadsheet B) column D then i can use a "IF" formula to copy the
code in the same row next column.
I hope you understand the Question.

regards

Davide

 

[Domenic]

If I understand you correctly, and assuming your data starts on the
second row, enter the following formula in G2 of Spreadsheet A, and copy
down:

=VLOOKUP(F2,'Spreadsheet B'!$D$2:$E$10,2,0)

Adjust the range accordingly.

Hope this helps!