Look up

  • Thread starter Thread starter Jacqueline
  • Start date Start date
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
 
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)
 
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
 
Back
Top