Formula Won't Work

Dathan

New Member
Joined
Oct 25, 2006
Messages
49
Can anyone explain why this formula works:

=LOOKUP(REPT("z",255),A2:A10)

And the one below doesn't work?

=LOOKUP(REPT("z",255),A2:R2)

In advance, thanks!
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,258
In what sense does it not work ?

They both return a value for me, although I'm not sure what they are meant to do.
 

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
Hello Dathan,

Both formulas should extract the last text value from the range, see my explanation in your other thread here

What result do you get and why is that not "correct"? Perhaps you were expecting it to do something else?
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
57,364
Office Version
  1. 365
Platform
  1. Windows
Can anyone explain why this formula works:

=LOOKUP(REPT("z",255),A2:A10)

And the one below doesn't work?

=LOOKUP(REPT("z",255),A2:R2)

In advance, thanks!
Just taking a guess... maybe A2:R2 contains cell(s) towards the end that contain formulas that return "" resulting in your lookup formula returning "" and you are thinking that it is not returning anything? :confused:

Or perhaps A2:R2 only contains empty cells and/or numeric cells?
 

Dathan

New Member
Joined
Oct 25, 2006
Messages
49
No, I'm actually just a moron. :unsure: :LOL:

I entered the formula in cell G1 but out of habit I set the range to A2:E2, so when I copied my formula down the results didn't match the spot checks for every row.

Sorry for confusion. :oops:


barry houdini, i am checking the explanations now, I'll follow up in that thread if I'm still confused. (highly likely :rolleyes:)

Thanks (y)
 

Forum statistics

Threads
1,181,607
Messages
5,930,871
Members
436,764
Latest member
avalladarez

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
Top