Excel Tips
Your Lookup Table Can Go Across »
April 13, 2022
Someone built this lookup table going across the worksheet. How can I use VLOOKUP?
Remove Leading and Trailing Spaces »
April 12, 2022
None of my VLOOKUP formulas are working. I can clearly see that there is a match in the lookup table, but Excel cannot see it.
Consider Naming the Lookup Table »
April 11, 2022
My lookup table is on another worksheet. The VLOOKUP is really confusing =VLOOKUP(A2,’Lookup Table Sheet’!$A$2:$B$30,2,FALSE).
Add New Items to the Middle Of Your Lookup Table »
April 8, 2022
I have to add BG33-9 to my lookup table. When I enter it in row 31, the #N/A error does not go away.
April 5, 2022
My VLOOKUPs aren’t working. It is returning other values from the table.
Use VLOOKUP to Join Two Tables »
April 4, 2022
My I.T. department gave me a data set with Item Number, Date, and Quantity sold. They didn’t put an item description in there. If I call back and ask them to re-do the file, it will take 3 weeks. Can I quickly fill in the item descriptions?
April 1, 2022
I've written a brilliant formula. Sometimes, due to the incoming data, the formula generates an error. How can I suppress the errors?