Offset an HLOOKUP

T

thomasbeard

Board Regular
Joined
Oct 19, 2005
Messages
139
I have a table of data that has merged cells in the top row that each take up three columns. The problem I have is that when I do an hlookup on this table, the data returned will be from the first column of each data set (ie, column A, D, G, J etc). Is there a way to offset the hlookup to return data from the second column (i.e. B, E, H, K etc) without changing the structure of the spreadsheet?
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Sort by date Sort by votes
thomasbeard said:
I have a table of data that has merged cells in the top row that each take up three columns. The problem I have is that when I do an hlookup on this table, the data returned will be from the first column of each data set (ie, column A, D, G, J etc). Is there a way to offset the hlookup to return data from the second column (i.e. B, E, H, K etc) without changing the structure of the spreadsheet?
Click to expand...
See if this helps. Formula in A12 copied across and down.

Excel Workbook
ABCDEFGHI
1Item 1Item 2Item 3
21611162126313641
32712172227323742
43813182328333843
54914192429343944
651015202530354045
7
10
11Item 2
12162126
13172227
14182328
15192429
16202530
17
Lookup with merged cells
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question
Hlookup with range of values
Replies
1
Views
32
Cubist
Cubist
G
  • Question
Filling cells with multiple " IF " & " THEN " in the formula
Replies
0
Views
36
Guy Boot
G
Q
  • Question
Adding a sum function to my Vlookup/Hlookup
Replies
4
Views
349
Peter_SSs
Peter_SSs
B
  • Solved
SEARCHING ANOTHER WORKBOOK FOR CURRENT ACTIVE TEXT OFFSET AND RETURNING TEXT FROM 3 CELLS OFFSET FROM FOUND TEXT
2
Replies
11
Views
123
BAKELOVEMORE
B
A
  • Question
HLOOKUP External Source, but use Variable in the address
Replies
1
Views
297
Micron
M

Forum statistics

Threads
1,214,975
Messages
6,122,538
Members
449,088
Latest member
RandomExceller01

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top