Re: Lookup formula help

You should be able to do that quite easily. If you want to brush up on
your VLOOKUP formulas I have written a tutorial to explain the formulas
working:-

http://teachr.blogspot.com/2006/07/vlookup-tutorial-excel-intermediate.html

If this doesnt help, feel free to email me the file at
mattyboy150279@xxxxxxxxx and I will be happy to help.

Regards,
Matt
http://teachr.blogspot.com - For Excel Tips and Tutorials

jillteresa wrote:
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 :eek:


--
jillteresa
------------------------------------------------------------------------
jillteresa's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=9498
View this thread: http://www.excelforum.com/showthread.php?threadid=566745

.

Relevant Pages

  • XPCE and SWI-Prolog
    ... Does anyone know some good tutorials for XPCE, ... guide but it only goes so far. ... PS Can you make the tabs in a tab_stack vertical? ...
    (comp.lang.prolog)
  • Re: creating rounded/curved corners
    ... Even tutorials on how to make web ... that will consitute the end of tabs in a menu. ... These graphics are supposed to mimic a curve with one color on the ... take a look at the tabs in this site. ...
    (alt.graphics.photoshop)