Look up

[Jacqueline]

How can I lookup a value that is on the left side of the
lookup. For example

I want it to give me the DV# based on the DV Name on
another worksheet. The vlook up does not work because the
data needed is on the left side of the look up.

DV Store DM Name

4 321 Joe Bagg

5 891 Jane Wilks

 

[Jim]

Have a look at http://www.cpearson.com/excel/lookups.htm

 

[Paul]

How can I lookup a value that is on the left side of the
lookup. For example

I want it to give me the DV# based on the DV Name on
another worksheet. The vlook up does not work because the
data needed is on the left side of the look up.

DV Store DM Name

4 321 Joe Bagg

5 891 Jane Wilks

To look up name in A1:A10 and return the corresponding value from column C,
you would have used:
=VLOOKUP(name,A1:C10,3,FALSE)
Instead, to look up name in C1:C10 and return the corresponding value from
column A, use
=OFFSET(C1,MATCH(name,C1:C10,0)-1,-2,1,1)

 

[Mark Graesser]

Jacqueline,
You can use LOOKUP instead of VLOOKUP.

Example:
=LOOKUP(E1,B1:B10,A1:A10)

E1 - lookup value
B1:B10 - lookup array
A1:A10 - return array

Good Luck,
Mark Graesser
(e-mail address removed)

----- Jacqueline wrote: -----

How can I lookup a value that is on the left side of the
lookup. For example

I want it to give me the DV# based on the DV Name on
another worksheet. The vlook up does not work because the
data needed is on the left side of the look up.

DV Store DM Name

4 321 Joe Bagg

5 891 Jane Wilks