How can I lookup values from multiple columns

**dhiresh** · 01-23-2013, 05:36 AM

I have values on a separate worksheet i.e in Sheet2 columns G = January, N = February, U = March, AB = April and so on.

I want to lookup same values on Sheet1 in sequential order i.e H to be January, I to be February, J to be March and so on.
Please could you assist, how I can do this using formula.

Thx

**dilipandey** · 01-23-2013, 05:58 AM

Hi Dhiresh,

Suggest you to upload a sample workbook along with your expected results. thanks.

Regards,
DILIPandey
<click on below * if this helps>

**dhiresh** · 01-23-2013, 06:22 AM

Hi Dilip

Please find attached sample of what I am looking answers for on the Summary sheet.
Monthly sheet will have lots of info and stats data which need to be summarised on one page.

Rgds
Dhiresh

**visha_1984** · 01-23-2013, 06:55 AM

Dear pls find attached file.

**dilipandey** · 01-23-2013, 06:29 AM

You are already using below formula, which appears to be working fine

Formula:

=HLOOKUP(TRIM(H$20),MonthlyStats!$H$1:$H$6,4,FALSE)

what else and where you need more help ? thanks.

Regards,
DILIPandey
<click on below * if this helps>

**dhiresh** · 01-23-2013, 06:55 AM

Hi Dilip,
Hlookup is fine but I want to have values such as January'2012 (in cell H20), February'2012 (in I20), March'2012 (in J20) etc brought across to Summary sheet using formula rather than manually allocating these.

Rgds
Dhiresh

**dilipandey** · 01-23-2013, 07:43 AM

Okay..you

want to have values such as January'2012 (in cell H20), February'2012 (in I20), March'2012 (in J20) etc brought across to Summary sheet using formula

but from where (which location) ?

Regards,
DILIPandey
<click on below * if this helps>

**dhiresh** · 01-23-2013, 08:11 AM

Hi Dilip,

I would draw your attention to the Sample file I attached to this thread.

MonthlyStats worksheel contains months and Year ie Cells H1, O1, V1 ....

On the Summary sheet, I want the same info (ie month & year) to be returned in cells H20, I20, J20 for the Hlookups to then populate other values.

Hope this is clear.

rgds
Dhiresh

**dilipandey** · 01-23-2013, 09:02 AM

Okay.. use below formula in H20 and drag to right side :-

Formula:

=OFFSET(MonthlyStats!$H$1,0,7*COLUMN(A$1)-7)

See attached:- SAMPLE_23012012.xls

Regards,
DILIPandey
<click on below * if this helps>

**dhiresh** · 01-23-2013, 10:21 AM

Hi Dilip,

I have tried it and it looks good. Many thanks

Rgds
Dhiresh

**dilipandey** · 01-23-2013, 12:26 PM

You are welcome Dhiresh.. Cheers

Suggest you to mark this thread as [SOLVED].. Thanks.

Regards,
DILIPandey
<click on below * if this helps>

How can I lookup values from multiple columns

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How can I lookup values from multiple columns

Re: How can I lookup values from multiple columns

Re: How can I lookup values from multiple columns

Re: How can I lookup values from multiple columns

Re: How can I lookup values from multiple columns

Re: How can I lookup values from multiple columns

Re: How can I lookup values from multiple columns

Re: How can I lookup values from multiple columns

Re: How can I lookup values from multiple columns

Re: How can I lookup values from multiple columns

Re: How can I lookup values from multiple columns

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions