Pulling data automatically from another worksheet

**cegarbage** · 04-06-2012, 09:47 PM

I developed a document with a pull down menu that uses VLOOKUP commands to pull values for certain metrics for about 7 departments at work. We need to write variance explanations against those metrics.

I am trying to have staff write the metrics on a separate worksheet so management can view all the data I have automated on top and have the variance explanations appear dynamically from the other worksheet.

Thanks for reading..

**Haseeb Avarakkan** · 04-06-2012, 10:11 PM

Try this in Data sheet C33,

Please Login or Register  to view this content.

Then copy to D33, then select both & drag down.

**cegarbage** · 04-07-2012, 01:07 AM

It's pulling from column B on the variance tab instead of column C. Having a hard time figuring out how to change it. Please help! Thanks!

**Haseeb Avarakkan** · 04-07-2012, 03:04 AM

See the attached.

**cegarbage** · 04-08-2012, 12:38 AM

I have one more question. If no variance comment is needed, it is showing up as "0". How can i make it blank?

**Haseeb Avarakkan** · 04-08-2012, 05:58 PM

Assume the output always be a text value. so just add T() function.

=T(Old_formula)

**cegarbage** · 04-08-2012, 11:18 PM

Thanks again. That is perfect. i used vlookup more than match and index. I'm trying to understand what MATCH("zzzzz" means. Can you explain this part? Why is it looking for "zzzz"?