Look up

J

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
 
P

Paul

Jacqueline said:
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
Click to expand...

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)
 
M

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
[email protected]

----- 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
 
Top