My apologies if this has been addressed previously however, if it is in the forum, feel free to direct me. TY.
I recall Excel being able to do this but I can't remember the formula and I am tired of hitting my head on the desk, cause it's starting to hurt a bit.
Here is my case. I have a column that I enter account numbers in. In the next cell, I want it to search my other worksheet within my workbook for the account number and populate the account name.
I know I used to be able to do this but for the life of me, I can't recall the formula. I believe it had "if" and "vlookup" but seem to get the formula to work.
Please advise.
Thank you in advance.
excel_help.xlsx
Bookmarks