vlookup help pls...

  • Thread starter Thread starter Soth
  • Start date Start date
S

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
 
If the value 69003160 is in cell V1, put this in W1:

=INDEX(F:F, MATCH(V1, A:A, 0))
 
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
 
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.
 
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
 
A formula can only return a value to the cell the formula is in. A formula
can't "push" a value to another cell.
 
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.
 
Back
Top