combine vlookup and hlookup

=?Utf-8?B?TG9yaQ==?=

Guest

Posts: n/a

9th Apr 2007

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.

« Problem Saving with the 'Must Enable Macro' workaround | macro to increase a value and print »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vlookup and Hlookup Combine?	MyLan	Microsoft Excel Worksheet Functions	1	6th Jun 2008 04:19 AM
Combine Vlookup and Hlookup	=?Utf-8?B?c2VyZ2U=?=	Microsoft Excel Worksheet Functions	1	12th Mar 2007 03:35 AM
Re: combine HLookup & VLookup functions?	Max	Microsoft Excel Worksheet Functions	0	17th Sep 2004 03:51 PM
Re: Combine Vlookup with Hlookup	Steven M (remove dirt and invalid to reply)	Microsoft Excel Misc	2	10th Aug 2004 05:44 PM
Combine Vlookup with Hlookup	Frank Kabel	Microsoft Excel Misc	0	10th Aug 2004 05:18 PM