Vlookup using skip column

[avk]

I have two excel sheets. One is databank & second is list. Our data in databank sheet.

sheet : databank
column a is : name
column b is : address1
column b is : address2
column c is : city
column d is : district

sheet : list

column a is : name
column b is : city
column c is : district

Now i want in list sheet : name match with city & district respectively relevent name.
I m attaching file.

[Palmetto]

Adjust range references as needed. See attached.

=VLOOKUP($A2,DATABANK!$A$2:$E5,4,FALSE)

[hardeep.kanwar]

Or try this

Enter this in B2 and Drag as far as Your Range

=VLOOKUP($A2,DATABANK!$A$2:$E$5,COLUMN(D:D),FALSE)

[avk]

Adjust range references as needed. See attached.

=VLOOKUP($A2,DATABANK!$A$2:$E5,4,FALSE)

It is ok if in both sheets name in common row & column.

But if code in column A
address is column c

I want in c11 position : require "station inchage" we are trying but show like this #NA

If it is possible let me know.

[teylyn]

take a look at the VLOOKUP() function in help and try to understand how it works. Otherwise you'll be back here for each new cell you want to enter it into.

VLOOKUP(<what>,<where>,<column>,<approximate>)

=VLOOKUP($B11,DATABANK!$A$2:$C35,4,FALSE)

what - the value that you want to lookup. In your formula you are not referring to the correct cell. You need A11, not B11
where - the range of columns and rows that you want to look in. Your range is A2 to C35 on the Databank sheet.
column - the column from which you want to return a result. Your formula specifies "4" but your "where" only has three columns. You need a 3 here.
approximate - true or false, depending on whether you want an approximate result if an exact match is not found.

This should give you some pointers towards the correct formula.

[avk]

ok thanks. solved.

[teylyn]

please don't quote whole posts.