Hello Everyone,
I am trying to get the value of the last (left to right) "BID" and "ASK" entry in every row.
Basically I need somehow to find the last BID/ASK entry in every row and get the value next to it.
I've tried so far with INDEX, MATCH, Vlookup but without any success. Most likely I am doing something wrong or not setting up the parameters correctly.
Any help is much appreciated.
Thanks!
I am trying to get the value of the last (left to right) "BID" and "ASK" entry in every row.
Basically I need somehow to find the last BID/ASK entry in every row and get the value next to it.
I've tried so far with INDEX, MATCH, Vlookup but without any success. Most likely I am doing something wrong or not setting up the parameters correctly.
Any help is much appreciated.
Thanks!