Re: Vlookup with nested IF

Tech-Archive recommends: Fix windows errors by optimizing your registry


Sorry, I'm doing a poor job of getting my message accross here. Let me
try it from scratch.

Names are found in A1:A3000. Sometimes the same name will repeat
itself consecutively in column A, so the same name value could appear
in A1, A2, A3, A4, A5. In column CQ, their skill set appears, which
basically tells me what stats are in that row. This is the 509 value
(one of about 6 diff options).

I need to search column A for a name I specify, and find which, if any,
of the rows with the name in it also includes 509 in column CQ. If that
does occur, I want to excute the formula =CU?/M? with ? being the same
row as the name and 509. If no row includes the name I've entered with
509 in CQ of the same row, the cell remains blank.

Hopefully that's a little more clear.... thanks immensely for your
patience thus far.


--
guilbj2
------------------------------------------------------------------------
guilbj2's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=6043
View this thread: http://www.excelforum.com/showthread.php?threadid=568374

.