combine vlookup and hlookup
I'm developing a table that's basically from a destination (rows) to a
destination (columns). The formula I used is
=(VLOOKUP($J$20,B5:O17,14,FALSE)*AND(HLOOKUP($J$21 ,C4:O17,14,FALSE))) where
J20 is the from location, B5:017 is my range and I have a total of 14
columns; J21 is the to location.
It doesn't ready the hlookup.
|