Just need a little help with simple vlookup

VLOOKUP can lookup values to the left so, try this one instead

Formula:

Please Login or Register  to view this content.

VLOOKUP requires that the lookup value (11111) be in the left-most column of the lookup table.

Instead of this...

Data Range

	C	D
2	Assistance Name	Director #
3	Sarah	22222
4	Julie	33333
5	Samatha	11111

You need this...

Data Range

	C	D
2	Director #	Assistance Name
3	22222	Sarah
4	33333	Julie
5	11111	Samatha

Originally Posted by exced

none of the above work

can someone provide me with a bit more details

thanks

this is my reasoning;

=VLOOKUP(A1,Sheet2!$A$1:$B$100,2,FALSE)

mean

search value in A1 on sheet2 between A1 and A100.

If you find a match, provide me with the second column and false means I'm looking for an exact match.

Is that correct ?

I think you are wrong.

Please see attached.

Once I "flipped" the lookup table around it works for me...

Data Range

	C	D
2	Director #	Assistance Name
3	22222	Sarah
4	33333	Julie
5	11111	Samatha

Data Range

	B	C	D
2	Director #	Director Name	Secretary Name
3	11111	John	Samatha
4	22222	Peter	Sarah
5	33333	Sam	Julie

This formula entered in D3 and copied down:

=VLOOKUP(B3,Sheet2!C$3:D$5,2,0)

In M2-

Please Login or Register  to view this content.

Instead of Vlookup Index Match should be used here.
This is because Vlookup searches the first column in the range specified but index match is more flexible and can search columns from between the data also.

Based on your sample file in post #9...

This formula entered in M2 and copied down:

=INDEX(Sheet4!C:C,MATCH(B2,Sheet4!F:F,0))

Enter in M2 and copy down

Formula:

Please Login or Register  to view this content.

Good deal. Thanks for the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

Like this...

Data Range

	A	B	C	D	E	F	G	H
1	Secretary	Consultant		Consultant	Secretary
2	Judy	111		111	Judy	Bill	Sandy
3	Tina	222		222	Tina
4	Linda	333		333	Linda	Eric
5	Bill	111		444	Connie	Tracy
6	Connie	444		555	Tom
7	Tracy	444
8	Tom	555
9	Eric	333
10	Sandy	111
11	------	------	------	------	------	------	------	------

This array formula** entered in E2:

=IFERROR(INDEX($A:$A,SMALL(IF($B$2:$B$10=$D2,ROW(B$2:B$10)),COLUMNS($E2:E2))),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy down as needed then across until you get a column full of blanks.

Here's a sample file...