[vally]

I have an excel document.
In one column I have a number and I want to find if is in a different column and to return the data in the adjacent l over.
Thanx for any help

[Advertisements]

=vlookup([cell in column with number],[table range],2,FALSE)

So, let's say the numbers you want to look for are in column A, the number you want to find are in column Y - therefore the data you want to return is in column Z. Let's say you want to write this data to column B. In all cases, the data runs to row 100.


Formula in B2 would be =vlookup(A2,$Y$2:$Z$100,2,FALSE)

Drag this formula down the cells in column B.

[Vino Rosso]

=vlookup([cell in column with number],[table range],2,FALSE)

So, let's say the numbers you want to look for are in column A, the number you want to find are in column Y - therefore the data you want to return is in column Z. Let's say you want to write this data to column B. In all cases, the data runs to row 100.


Formula in B2 would be =vlookup(A2,$Y$2:$Z$100,2,FALSE)

Drag this formula down the cells in column B.

[vally]

Thanx
I managed to play around with it and get what I needed to use.