Will_D said:
Yes, they are all correct.
Thanks
I guess you did not get the intended results...
Recap:
You have a dropdown list of companies in A8 on Sheet1...
As you see, IBM is selected.
You have a table of companies along with their associated codes in O2:P33 on Sheet2. And this table is sorted in ascending order on column O, right?
Book5 |
---|
|
---|
| N | O | P | Q |
---|
1 | | Company | Code | |
---|
2 | | GOOGLE | Code-08 | |
---|
3 | | IBM | Code-09 | |
---|
4 | | INTEL | Code-05 | |
---|
5 | | MS | Code-07 | |
---|
6 | | ORACLE | Code-05 | |
---|
7 | | SHELL | Code-05 | |
---|
8 | | SUN MICROSYSTEMS | Code-04 | |
---|
|
---|
And you want to retrieve the company code associated with Sheet1!A8 in A8 on Sheet2 and I suggested:
The formula in A8 is:
=IF(LOOKUP(Sheet1!A8,$O$2:$O$33)=Sheet1!A8,LOOKUP(Sheet1!A8,$O$2:$P$33),"Not Found")
So, what is the problem that you seem to have?