Hi!
I'm struggling with the following problem and would really appreciate some help:
1. I have 2 sheets in my workbook "Key" and "Database". Database contains a 'Index-Match' table, whose source is Key. The formula for a cell in Database looks something like this:
=INDEX('Key'!$B$13:$P$104, MATCH($B18, 'Key'!$B$13:$B$120,0), MATCH(I$17, 'Key'!$B$13:$O$13,0)))
The issue is that the column in Key that Database is pulling values from has numbers, %, dates etc., all mixed. So I am looking to have Index-Match pull the value as well as formatting (currently not doing the latter).
E.g., if the matched value in Key is 30%, the corresponding cell in Database is pulling 0.3.
I understand that there may be a way to do this with VBA, but I don't know how to unfortunately.
Any help is much appreciated! Thank you!!
I'm struggling with the following problem and would really appreciate some help:
1. I have 2 sheets in my workbook "Key" and "Database". Database contains a 'Index-Match' table, whose source is Key. The formula for a cell in Database looks something like this:
=INDEX('Key'!$B$13:$P$104, MATCH($B18, 'Key'!$B$13:$B$120,0), MATCH(I$17, 'Key'!$B$13:$O$13,0)))
The issue is that the column in Key that Database is pulling values from has numbers, %, dates etc., all mixed. So I am looking to have Index-Match pull the value as well as formatting (currently not doing the latter).
E.g., if the matched value in Key is 30%, the corresponding cell in Database is pulling 0.3.
I understand that there may be a way to do this with VBA, but I don't know how to unfortunately.
Any help is much appreciated! Thank you!!
