vlookup with structured table (Insert-->table)

[lezawang]

Hi
Is it good idea to name insert a table (Insert-->table) on the sheet I am working with when I use Vlookup() function?

vlookup(x, table1, 3,false)

I thought it is not good idea because if the lookup value (x in this case) is not in the first column then I need to highlight the range to make x as first column and with that using table1 wont help me. Am I right? Thank you so much.

 

[Aladin Akyurek]

Book1
	A	B	C	D	E	F
1	correspondent	code	city
2	jon	30	london		nate	nottingham
3	nate	25	nottingham		istanbul	dan
4	dan	80	istanbul		90	den haag
5	johan	90	den haag
6
Sheet1

F2 runs a left-to-right straight VLOOKUP...

=VLOOKUP(E2,Table1,3,0)


F3 runs a right-to-left VLOOKUP against a table constructed by means of a CHOOSE call...

=VLOOKUP(E3,CHOOSE({1,2},Table1[city],Table1[correspondent]),2,0)


F4 runs a left-to-right VLOOKUP against a subtable of Table1...

=VLOOKUP(E4,Table1[

:[city]],2,0)


Hope this helps.