Lookup function

M

MARKEGANDERSON

Active Member
Joined
Apr 7, 2007
Messages
264
Hello All,

I am having a slight problem with the Lookup Function:

Cell V1082 contains the the date 01 nov 08, which is a merged cell(1082:1090)
The adjacent cells W1082:W1090 are not merged cell( the have different values in each cell)

When I use the Lookup funtion it only grabs the Value in W1082,

I am trying to lookup the date(merged cells) and reads the adjacent cells(unmerged)

How can I accomplish that?
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Sort by date Sort by votes
MARKEGANDERSON said:
Hello All,

I am having a slight problem with the Lookup Function:

Cell V1082 contains the the date 01 nov 08, which is a merged cell(1082:1090)
The adjacent cells W1082:W1090 are not merged cell( the have different values in each cell)

When I use the Lookup funtion it only grabs the Value in W1082,

I am trying to lookup the date(merged cells) and reads the adjacent cells(unmerged)

How can I accomplish that?
Click to expand...

1) Unmerge the cells.
2) Run the lookup formula.
3) If the lookup is successful, merge the cells if still desired.
4) If the lookup is unsuccessful, try to diagnose why the formula does not work. And, post back with the formula included.
 
Upvote 0
=LOOKUP($J$32,NS_Tally!V1082:V1360,NS_Tally!W1082:w1360)

I am thinking its reading one value for the merged cell(V1082)-the date 02 Nov 08 and returning back one value in the the result vector (W1082) and ignoring the other cells W1083:W1090
 
Upvote 0
MARKEGANDERSON said:
=LOOKUP($J$32,NS_Tally!V1082:V1360,NS_Tally!W1082:w1360)

I am thinking its reading one value for the merged cell(V1082)-the date 02 Nov 08 and returning back one value in the the result vector (W1082) and ignoring the other cells W1083:W1090
Click to expand...

I think you did not follow the advise...

Try if this guess succeeds...

=INDEX(NS_Tally!W1082:W1360,MATCH($J$32,NS_Tally!V1082:V1360,0))
 
Upvote 0
i DID TAKE YOUR ADVICE, I TRIED IT BEFORE YOU GAVE IT, THATS HOW i KNOW IT DIDNT WORK...

THE INDEX WORKS WEL!!!!

THANK YOU SO MUCH!
 
Upvote 0
Smitty i tried this formula:=VLOOKUP($J$32,NS_Tally!W1082:W1126,2)

It came back with a #REF! error..

Thanks in advance.
 
Upvote 0
You must log in or register to reply here.

Similar threads

U
  • Question
Type Mismatch Error
Replies
9
Views
188
Alex Blakenburg
A
Dan Wilson
  • Solved
Help with a Run-Time Error
Replies
4
Views
220
dreid1011
dreid1011
J
  • Solved
INDEX MATCH Function Help
Replies
6
Views
232
jeffj13
J
S
  • Question
VBA Code to Copy Dashboard Date Data, Lookup that Date on YTD Data tab, and Paste Value?
Replies
1
Views
231
SirGruffles
S
S
  • Question
Two way lookup in a row for last row value
Replies
5
Views
398
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,214,812
Messages
6,121,699
Members
449,048
Latest member
81jamesacct

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