I have been trying to calculate some cells based on criteria located in
several other locations.
vlookup range name = rangecorrection
For example, trying to return a value for cell C5. However the information
is in worksheet "Correction Values" and will require the formula to search
"BAAA 2.0" in column Aof the above mentioned worksheet as well as "TS" in
column B in order to return the value (see below for example)
currently have formula:
=VLOOKUP(B4,rangecorrection,3,FALSE)&VLOOKUP(C4,ra ngecorrection,3,FALSE)
Column A Column B Column C
BAAA 2.0 TS
Row 1 .................. 130 #N/A
Row 2 ................... 230 #N/A