=INDEX(Sheet2!B$1:B$9,MATCH(ROW(),Sheet1!A$1:A$9,0 )) in sheet 3 B1, & copy
down ?
--
David Biddulph

"RMarquez" wrote in message
...
I understand that there must be a better way, but I'm not sure how. I'll
explain to you what I'm trying to do, please let me know if you can help.

I have worksheet 1 where I enter 9 rows of data, 4 columns of info.
This data is translated into worksheet 2, which prioritizes the 9 rows
based
on the 4 column criteria.
Now I'm on worksheet 3. I would like to pull the data from worksheet 2,
after it's been prioritized and relist in on worksheet 3 in order of
importance 1 through 9.

But I can only nest 7 IF's, not 9. So IF any of worksheet 2 cells a1-a9
have a "1" in it, enter the corresponding worksheet-2, column-B data into
Worksheet 3's B1 cell.

Is this clear? Please let me know if you can help. Thanks!

"Bob Phillips" wrote:

If you don't have Excel 2007, you can't. If you do have Excel 2007, you
shouldn't.

Tell us what you are trying to do, in words, there is bound to be a
better
way.

--
__________________________________
HTH

Bob

"KenCanuck" wrote in message
...
I need to nest about 13 IF functions in one formula, can I do this?