Category: Lookup and References

One of the power of combining functions in one cell is using the best of these functions An example is here, OFFSET + MATCH will...

To do a search in a column or a row, MATCH is the function to look for It is very simple, you set the value...

I don’t believe I don’t have this here yet. This is one of my oldest tricks When we have to do links between two workbooks...

I have been asked for a while now to just put a simple VLookup function, here it is, I know this might be stupid to...

I need that more often than I thought It is basically extract the full workbook name that we are in, with no folders, and with...

I think if there is a single function that would be a huge threat to VBA and macros from user perspective, it would be INDIRECT()...

Excel already has the formula ROW() =Row() Which as we may already know will give us the number of the row we are in, if...