Re: Lookup formula help

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Jill,

Yes, you can check and retrieve the information using the VLOOKUP
function using nested IFs or better you use IFs and ORs.

Do send me a sample work*** so that I can help you in it.

Thanks

Shail


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

.

Quantcast