Hi there,
I need to input a vertical formula that will retreive info based on a
code that could be on one of four tabs.

I'd like to develop a work order that will allow me to enter a code and
have all related creative information populate. For instance, promotion
code 1004 is in Column A on either the Q1, Q2, Q3 or Q4 tab. I need the
related creative name located in column G. The promotion code will
only appear once on only 1 tab.

Can I enter the vertical lookup formula to check all tabs and retreive
the information?

Jill


--
jillteresa
------------------------------------------------------------------------
jillteresa's Profile: http://www.excelforum.com/member.php...fo&userid=9498
View this thread: http://www.excelforum.com/showthread...hreadid=566745