I need to Do a VLOOK UP with IF..
IF Cell Contains YES, Then do a VLOOKUP up on 1 range with 3 Criteria separate but from the same Range...
For
SO If A1 Says YES
then
VLOOKUP RANGEA,CELL#1
VLOOKUP RANGEA,CELL#2
VLOOKUP RANGEA,CELL#3
Help please with one formula