Which is it, CU or M? What I gave you looks for name in column A, 509 in CQ,
and returns that name if found, else blank.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"guilbj2" wrote in
message ...

Hi Bob,

Thanks a ton for your input. I omitted one item that I'll need the
formula to accomplish... I guess I figured I'd be able to sort it out
once I got the lookup issue resolved, but your formula is definitely
above my pay grade and I'm a little uncertain of where to insert it.

The value that I need returned is column CU/ column M, with the row
being determined by the row 509 (or other value i choose) is located
next to the person's name. If the 509 value is located next to the
person's name @ CQ?, the value I need returned is =CU?/M?, otherwise,
the cell remains blank.

I tried pasting your formula into my sheet to try and play with it to
see where I could get, but it only returns a #VALUE!

Any chance you have time to indulge me w/ a follow up ?


--
guilbj2
------------------------------------------------------------------------
guilbj2's Profile:
http://www.excelforum.com/member.php...fo&userid=6043
View this thread: http://www.excelforum.com/showthread...hreadid=568374