VLOOKUP Table Values Hello, I have 12 different tables named Jan, Feb, Mar, etc.

Question

VLOOKUP Table Values

Hello,

I have 12 different tables named Jan, Feb, Mar, etc. I will be dumping ddata into these tables on a monthly basis. I have twelve different columns with the specific month name at the top (Jan, Feb, Mar, etc.). I want to build a VLOOKUP that will search in the table for that montth.

I know how to hard code the table name in to the formula as follows:

=-IF(ISNA(VLOOKUP(CONCATENATE($B7,".",$B$6),Aug,3,FALSE)),0,VLOOKUP(CONCATENATE($B7,".",C$6),Aug,3,FALSE))

Rather than hard coding the table name in each column, I would like to have a formula that retrieves the text in the cell at the top of the row and returns my table name. For example, if cell A1=

Explanation / Answer

Change your formula to,

=-IF(ISNA(VLOOKUP(CONCATENATE($B7,".",$B$6),INDIRECT(Aug),3,FALSE)),0,VLOOKUP(CONCATENATE($B7,".",C$6),INDIRECT(Aug),3,FALSE))

I believe in your above formula C$6 (Bold) shhould be $B$6. If that is the case theen just use IFERROR instead of IF and ISNA if you don't need to use this file in office 2003

So your formula should be shorted to,,,

=-IFERROR(VLOOKUP(CONCATENATE($B7,".",$B$6),INDIRECT(Aug),3,FALSE),0)))

Related Questions

Navigate

• Browse (All)
• Browse V
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.