Having trouble with a IF/VLOOKUP formula that has conditions

[lemondifficult]

Hi,

I'm having trouble writing a IF/VLOOKUP formula that will either show the cell as blank when the cell being looked up is blank, contains an asterisk or when the cell being looked up doesnt exist in the table, and when the cell is found and doesnt contain an asterisk then it returns the value of the cell.

Essentially:

If VLOOKUP = Blank or Contains * or does not exist in table
Then Blank
Else VLOOKUP

I managed to get the formula working when the cell being looked up is blank or doesn't exist in the table (using a combination of IF, ISBLANK and IFERROR), however the condition for when the cell contains an asterisk is what im having trouble with.

Is anyone able to provide some guidance on this? Any responses would be greatly appreciated!

Thanks in advance,
Micheal

 

[lemondifficult]

sorry for the bump, but is anyone able to help on this?

 

[Peter_SSs]

Try

=IFERROR(IF(OR(your_vlookup={"","*"}),"",your_vlookup),"")