I have a sheet on which values relating to website URL redirect chains are returned. At the end of each row, I want to return the final URL and its HTTP response. These values are populated by
VLOOKUPs done on other sheets, so where a chain is short, the "blank" cells aren't strictly blank.
From the example above, I'd want to return the values
200. I've been trying to adapt things like this without success.
NB: In case it makes a difference, the hash values are there because some of the URLs are too long to
VLOOKUP, so the lookups are done on hashes.