Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi all,
my first file ========== (a) (b) (c) (d) sno name pincode area 1 arun 123456 * 2 kumar 123457 * 3 raja 123458 * note: ==== * how to get area from my second file (like vlook up) conditions: ======== with out change fields order in both file. my second file =========== (a) (b) area pincode abc 123456 bcd 123458 cde 123457 my third file ========== (a) (b) (c) (d) sno name area pincode 1 arun * 123456 2 kumar * 123457 3 raja * 123458 note: ==== * how to get area from my second file (like vlook up) conditions: ======== with out change fields order in both file. pls anyone help this questions . i am awaiting for urs reply. Regards, vinci |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Which is faster: VLOOKUP-worksheet or VB-array VLOOKUP? | Excel Programming | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |