Hello,
I need help with a formula that will allow me to lookup a value in an array and if it is blank get the next available value.
Cannot past a pic of the spreadsheet.
Hello,
I need help with a formula that will allow me to lookup a value in an array and if it is blank get the next available value.
Cannot past a pic of the spreadsheet.
Without specifics it's hard to help, but the VLOOKUP, HLOOKUP and LOOKUP functions have the ability to search for an exact match, or next closest alternative.
Please add reputation by clicking on the * if I have helped.
Please mark the thread SOLVED if your issue has been resolved.
Thanks, Glenn.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks