PDA

View Full Version : Solved: Extract Data for specific columns - Formula



vishwakarma
01-11-2011, 06:12 AM
Hi Guys,

I’ve a data in excel sheet with multiple columns. I need to extract all the values of some specific columns in the sheet . I don’t need a macro instead want to use formula to do this part…

Can this be done…

Attached is the sample excel workbook for the reference…


Thanks is advance...

shrivallabha
01-11-2011, 07:05 AM
Let me know if I have misunderstood your requirement. All you need to do is:
1. Set Up the first row by using formula =Range
e.g. A31 = B2

2. Complete as many columns for single row.

3. Use Excel autocomplete.

I am attaching the workbook.

vishwakarma
01-11-2011, 10:35 PM
Hi Shrivallabha,

Actually I was looking for a function by which we can lookup the header row and retrive all the data of it..just like we do through VLOOKUP.

I have got the solution now, through HLOOKUP I can do this stuff... Thanks for the idea...


Cheers,