VLOOKUP ? IFERROR ? CHOOSE ? Problem

[yesitskez]

Hi,

I am struggling to work the best way out to do this, I have one table that has a unique number for each entry, followed by a date, customer, Nett value, VAT, gross and number of other values. I am trying to do a backwards vlookup to the customer, so if it finds the customer it will display the date,
=IFERROR(VLOOKUP($A$1,CHOOSE({1,2},Sheet1!C:C,Sheet1!B:B),2,),"")
This same customer would have a number of entries in one month and I will need to find all the dates.
In the next column if the is a value in the first column it returns the customer name relevant to that entry.
=IFERROR(VLOOKUP($A$1,Sheet1!C:C,1),"")

Your help and guidance would be really appreciated in helping me.

[ConneXionLost]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[yesitskez]

Sorry I have now changed it

[judgeh59]

for the first lookup you can use the INDEX/MATCH combo
If I understand what you are trying to do there...

=INDEX(Sheet1!B:B,MATCH(Sheet2!A1,Sheet1!C:C,0)) .... this goes in Sheet2!A3......HTH....I'm still working on the second part

[yesitskez]

Thank you judgeh59, I did try INDEX and MATCH but kept getting the same date repeating "02/04/13", when you look in sheet1 this customer has 21 entries on different dates.

[judgeh59]

so, actuallity you are trying to get every instance of what you put on Sheet2!A1....is that correct?

[yesitskez]

Hi judgeh, Yes in the first column I am.

[judgeh59]

okay I have the first one done.....check it out....

[yesitskez]

Spot on..... Thank you

[judgeh59]

My Pleasure....I assume you want to fill in the other columns with associated data....you should be able to use the first one to create the others....have fun....

[yesitskez]

I will, thanks very much.

[judgeh59]

no problem and thanks for the "*"

[yesitskez]

I just copied it across =IFERROR(INDEX(Sheet1!$B$2:$C$300,SMALL(IF(Sheet1!$C$2:$C$300=$A$1,ROW(Sheet1!$C$2:$C$300)),ROW(Sheet1!1:1)),2),""), but it did not match ? it returned "Climate-Control 2" ? where did I go wrong ?

[yesitskez]

Can any one else advise on this ?

[judgeh59]

Check out this solution for that columns....will there be other columns that you want looked up?....

[yesitskez]

Hi Judgeh, Thank you for the help, Yes I would need to see any one of the columns from D to I in sheet 1.

[judgeh59]

Think I got it.....

[yesitskez]

Cant see wants gone wrong ?