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

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Excel HELP!!

ACE1987 Avatar
7y, 1m agoPosted 7 years, 1 month ago
Good Morning

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


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


=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, 1m agoPosted 7 years, 1 month ago

All Comments

(5) Jump to unreadPost a comment
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.
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

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!