PROVLEM RELATED TO VLOOKUP

[VIKRAM]

Dear Sir,

I have a data like this

DP ID Address Contact Person

55600 403, 4TH FLOOR MR. ANKIT GUPTA

43600 SHREYAS, BUNGLOW NO. 70/74 SUDHIR KUMAR GUPTA

28400 I.T.T.S HOUSE, 2ND FLOOR MR.BIMAL A CHOKSI

59200 13, VAISHALI MR. HARGOBIND SINGH NEGI

64800 NO. 11, ONGC BUILDING NO. 3 MR. SATYAM S. JOSHI

15000 BM-1, DILKHUSH INDUSTRIAL & SHRI. ASHISH AGARWAL

66000 1ST FLR, ABHYUDAYA BANK BLDG. MR. MADHUSUDAN J RAJPURKAR


Now i have only DP ID and want to get ADDRESS, CONTACT, PERSON, BY USING VLOOKUP. How it will get all 3 coloums by using vlookup function.


Thanks & Regards

Vikram Singh

Email id- vikramniit432@gmail.com

 

[keymaster]

Welcome to Chandoo.org forums and thanks for your question. Please take time to explore our forums to learn better. Read the 3 sticky threads on front page too.


Regarding your question, assuming the DP id is in A1 & your data in A4:D10 write


=VLOOKUP(A1,$A$4:$D$10,2,false) & VLOOKUP(A1,$A$4:$D$10,3,false) & VLOOKUP(A1,$A$4:$D$10,4,false)


This concatenates all results in to one cell.


To learn more about VLOOKUP, please read - http://chandoo.org/wp/2012/03/30/comprehensive-guide-excel-vlookup/

 

[kchiba]

Using Chandoo's example you can use the Array formula


{=VLOOKUP(A1,$A$4:$D$10,{2,3,4},0)}


cheers


kanti