Tag Archives: VSTACK

VLOOKUP across tables is so easy in #Excel365

Again, a picture tells a thousand words. The following GIF shows what we want to achieve: Seriously? A simple VLOOKUP formula stated below would do. What’s the challenge? =VLOOKUP(G3,B:E,4,FALSE) Yes, you are right if all these tables reside on the same worksheet. What if … Continue reading

Rate this:

Posted in Excel 365, Formula | Tagged , , | Leave a comment