Excel HELP!! - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HotUKDeals, you accept our cookie and privacy policy.
Get the HotUKDeals app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Excel HELP!!

£0.00 @
Good Morning I am trying to use the functionality as descriped in the below link: http://office.microsoft.com/en-gb/ex...260381033.aspx I have copied the data exactly from the example table a…
ACE1987 Avatar
7y, 4m agoPosted 7 years, 4 months ago
Good Morning

I am trying to use the functionality as descriped in the below link:

http://office.microsoft.com/en-gb/ex...260381033.aspx

I have copied the data exactly from the example table and the formula from the website but I receive a #Ref error in cell B10 when I get to the following point:

Return corresponding values from column B

Forumla

=INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1 :$A$7)),ROW(2:2)))

Any help is much appreciated.
ACE1987 Avatar
7y, 4m agoPosted 7 years, 4 months ago
Options

All Comments

(5) Jump to unreadPost a comment
Comments/page:
banned#1
This Web page is unavailable
banned 1 Like #2
Need to send us the link again.

Edit - I think I found it. http://office.microsoft.com/en-us/excel/HA012260381033.aspx

Also - use B9 instead of B10.
banned#4
=index($a$1:$b$7,small(if($a$1:$a$7=$a$9,row($a$1:$a$7)),row(1:1)),2)
#5
Great! Thanks Alot every1

Rep added

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Looking for Twitter login?
Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!