Feb 27 2022 05:40 PM
=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?
Feb 27 2022 06:00 PM
Feb 27 2022 06:31 PM
@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.
Feb 27 2022 10:13 PM
Feb 28 2022 09:27 AM
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!!