I have some transposed data and I wish to use VLookup on that data but it does not seem to work. The transposed data contains both numbers and letters so I cant just copy it by "=value()"