Yeah, I figured as much. But sometimes I post for my own amusement.

Sorry about that!

wmjenner wrote:

I didn't mean you, Dave, I meant Mogle. I KNOW you have this stuff
down. I tried the formula as he gave it and got #N/A! because I had it
backwards (vlookup instead of hlookup). As soon as I switched it, I got
the values as expected.

--
wmjenner

------------------------------------------------------------------------
wmjenner's Profile: http://www.excelforum.com/member.php...fo&userid=5282
View this thread: http://www.excelforum.com/showthread...hreadid=394267

--

Dave Peterson