I have read some of the other posts, but can't seem to get the suggested formulas to work right. I've tried using vlookup, isblank, index/match, etc.
I have a summary sheet in one tab where I want to lookup a tank number in the first column and get the first non-blank result for that tank...