Formula Help with Lookups?
If you look up VLOOKUP in Excel help, it will tell you the syntax of the
function.
--
David Biddulph
"Bombay" wrote in message
...
Thanks for the speedy Response :)
Okay what does the 2 represent in the formula?
"Sheeloo" wrote:
Hello Bombay (or should I say Mumbai? :-)
Enter this in D1 and copy down
=VLOOKUP(C1,A:B,2,False)
"Bombay" wrote:
I am trying to find a formula/Function that will help me do the
following.
Table.
Column A: List of Names
Column B: Numerical Values
Column C: List of Names
Column D: Empty
A function that will fill in Column D with a Numerical Value found in
Column
B where Column A = Column B.
Example Data.
Column A
Row 1 Jimmy
Row 2 Steve
Column B
Row 1 '4'
Row 2 '8'
Column C
Row 1 Steve
Row 2 Jimmy
Column D
Row 1 Empty
Row 2 Empty
After putting in this formula Column D should look like
Row 1 '8'
Row 2 '4'
Thanks
|