I need help to look up value from multiple columns of data - Excel 2007
I have two worksheets, Sheet1 and Sheet2. Sheet1 has a table with 2 headings, Class and Category. In Sheet2, i have multiple columns of Categories and corresponding numbers in sequence. I need to be able to look up that number based on what is entered under category on sheet1. See the attached file.
User Form 2.xlsm
Last edited by kaurka; 10-25-2012 at 04:10 PM.
Hello,
I have looked at it and seems to me that you need to re-arrange the data in sheet 2. I have done in the sheet 4 in the attached file. If you keep it this way you will find quite easy to pull the required information from there.
Regards
Simon
...and this is when I walk in, dressed fully in white...
Perhaps dependent lists is what you need?
To make it easier for myself I cut table in the sheet 2 and pasted to Sheet 1.
=INDEX(CHOOSE(INDEX(F:F,MATCH(A2,E:E,0)),H:H,J:J,L:L),MATCH(B2,CHOOSE(INDEX(F:F,MATCH(A2,E:E,0)),G:G,I:I,K:K),0))
I added the file,
That works great!! How would i write a code to lookup from sheet2?
Glad to hear you liked it. Right now I have no time to write it down. But I will, after work I will show by adding file.
Sorry for that
thank you friend! I appreciate your time and effort!
a good guy !
cheapfootballshirtuk.co.uk
You are welcome kaurka, Its a pleaseure for me
Here is the formula
=INDEX(CHOOSE(INDEX(Sheet2!B:B,MATCH(Sheet1!A2,Sheet2!A:A,0)),Sheet2!D:D,Sheet2!F:F,Sheet2!H:H),MATCH(B2,CHOOSE(INDEX(Sheet2!B:B,MATCH(Sheet1!A2,Sheet2!A:A,0)),Sheet2!C:C,Sheet2!E:E,Sheet2!G:G),0))
you're a genius! thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks