vlookup help pls...

[Soth]

Scenario -

A F V

11701001 $10 69003160
22130001 $20 69003121
69003120 $30 69003120
69003121 $40
69003160 $50
---------------------------------------------------
I'd like to lookup column V and column A numbers, if matches then return the
value in column F into column V which is what at i'm trying to accomplish.
Please help with me formula. I've try vlookup myself but don't know what i'm
doing.

Thank you,
Soth

 

[JBeaucaire]

If the value 69003160 is in cell V1, put this in W1:

=INDEX(F:F, MATCH(V1, A:A, 0))

 

[Soth]

Hi -


I'd like to see the result in colum V let's say line 200 since they are
matched.
V200 =30
V201=40
V202=50

 

[JLatham]

You're not going to be able to preserve the numbers in column V *and* replace
them with the results of a lookup. You've either got to put the lookup
formula somewhere other than in V, or move the contents of V and put the
lookup formula into V.

 

[Soth]

Okay, let's say my lookup formula in column G, and I'd the value in colum F,
and what would the formula be?

Soth

 

[T. Valko]

A formula can only return a value to the cell the formula is in. A formula
can't "push" a value to another cell.

 

[JLatham]

Ok, lets say all of your example information begins on row 2. To match the
value at V2, the formula would be:
=VLOOKUP(V2,A$2:F$6,6,FALSE)
That will work in any cell in any column, other than A:F and V, so column G
would be just fine.