ExcelBanter - combine vlookup and hlookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - combine vlookup and hlookup (https://www.excelbanter.com/excel-programming/387093-combine-vlookup-hlookup.html)

Lori

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.

All times are GMT +1. The time now is 10:27 AM.