View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lori Lori is offline
external usenet poster
 
Posts: 272
Default 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.