lookup across sheets

**VBA Noob** · 10-12-2007, 08:41 AM

Some links re if statements

However if you need more than 7 if's you might be better off setting up a table and doing a vlookup

http://www.usd.edu/trio/tut/excel/adv/26if.html

http://www.cpearson.com/excel/nested.htm

http://www.j-walk.com/ss/excel/usertips/tip080.htm

VBA Noob

**VBA Noob** · 10-12-2007, 09:01 AM

Maybe a macro might be better.

See attached example. Code from this link

http://www.ozgrid.com/VBA/VlookupAllSheets.htm

VBA Noob

**drchris** · 10-12-2007, 09:26 AM

that is perfect

i even said 'wow' a bit loudly in the office when i got it to work and ppl were looking at me funny

thank u both oldchippy and vba_noob

**VBA Noob** · 10-12-2007, 09:34 AM

Glad you got a couple of solutions for your problem.

VBA Noob

**oldchippy** · 10-12-2007, 09:39 AM

Originally Posted by drchris

that is perfect

i even said 'wow' a bit loudly in the office when i got it to work and ppl were looking at me funny

thank u both oldchippy and vba_noob

Always glad to help - thanks for the feedback