• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

lookup and return first cell value ignoring blanks

R

Rodrigues

Member
Dear All
Not sure how to explain this, I'm looking for a formula, return the first (time result) match, ignoring blank cells.
Formula needed on "First transaction.xlsx" in cell "B2", exact match of cell A2

Source file "2016-12-15 Production Report 0600-0800.csv" (had to rename it to sxxl to be able to upload it).
Look on column "O"
Return first match found in column "E".
example:
"First transaction.xlsx" cell "B2 and B3 with results I'm looking for.
Thanks in advance.
regards
R
 

Attachments

  • 2016-12-15 Production Report 0600 - 0800.xlsx
    11.9 KB · Views: 4
  • First transaction.xlsx
    10.4 KB · Views: 3
PCosta
Thank you for your reply, just one question, have modified to read .csv, however have to open the csv source file first to read/extract data, it is possible to extract the data without having to open the .csv?
Thanks again
Regards
R
 
Rodrigues said:
PCosta
Thank you for your reply, just one question, have modified to read .csv, however have to open the csv source file first to read/extract data, it is possible to extract the data without having to open the .csv?
Thanks again
Regards
R
Click to expand...
If you use the full path to the source file in the formula, instead of just using the name of the source file, it will no longer require you to open the source to read the data
 
You must log in or register to reply here.
Back
Top