Vlookup what is F27 in this function?

%3CLINGO-SUB%20id%3D%22lingo-sub-3219287%22%20slang%3D%22en-US%22%3EVlookup%20what%20is%20F27%20in%20this%20function%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3219287%22%20slang%3D%22en-US%22%3E%3CP%3E%3DIFERROR(VLOOKUP(%24A%245%2C'Master%20Totals'!%24B%241%3A%24EG%24210%2CF27%2CFALSE)%2C%22%22)%3C%2FP%3E%3CP%3EI%20thought%20the%20column%20number%20what%20just%20a%20number%20but%20this%20function%20has%20F27.%20Where%20does%20excel%20look%20for%20the%20answer%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3219287%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3219341%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20what%20is%20F27%20in%20this%20function%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3219341%22%20slang%3D%22en-US%22%3EIt%20looks%20for%20the%20value%20that%20is%20in%20cell%20F27.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3219351%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20what%20is%20F27%20in%20this%20function%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3219351%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F675152%22%20target%3D%22_blank%22%3E%40JMB17%3C%2FA%3E%26nbsp%3BI'm%20confused.%20lol%20I%20thought%20that%20after%20the%20array%2C%20that%20number%20should%20be%20the%20numbers%20of%20columns%20to%20the%20right%20that%20it%20finds%20the%20answer.%20So%20it%20should%20just%20be%20a%20number%2C%20not%20a%20particular%20cell.%20Right%3F%20And%20also%2C%20I%20looked%20at%20F27%20and%20it's%20not%20the%20answer%20given%20in%20the%20cell.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

=IFERROR(VLOOKUP($A$5,'Master Totals'!$B$1:$EG$210,F27,FALSE),"")

I thought the column number what just a number but this function has F27. Where does excel look for the answer?

4 Replies
It looks for the value that is in cell F27.

@JMB17 I'm confused. lol I thought that after the array, that number should be the numbers of columns to the right that it finds the answer. So it should just be a number, not a particular cell. Right? And also, I looked at F27 and it's not the answer given in the cell.

Cell F27 should contain the column number in the range 'Master Totals'!$B$1:$EG$210 from which to return a value.

So, let's just say F27 contains the number 5. The formula would look up whatever is in cell A5 in 'Master Totals' column B and return the value from 'Master Totals' column F (fifth column in the range 'Master Totals'!$B$1:$EG$210).

Now, whether or not there is some kind of error that causes the formula to return an incorrect result or it's not working as intended (maybe it's the wrong function for the job), I couldn't say.

@JMB17 

Thanks so much for your info. That's exactly what I thought but that's not what is coming up in this cell so I couldn't figure out what they did. So I just used a different formula.

I appreciate your help!!