IF function along with variables

I've attached an image of what I would like to have happen - hope it helps!

Michelle

Anyone have even a suggestion?

Thanks!
Michelle

Michelle

B1: =IF(ISNA(VLOOKUP(A1,$C$1:$E$5,3)),"ERROR",VLOOKUP(A1,$C$1:$E$5,3))

Copy down to B3.

You don't really need the column D data. If you remove it, you can use the VLOOKUP over 2 columns.


HTH

rylo

I couldn't get it to work properly, but thank you for your efforts...

I think at this point it would be easier to just pay someone to take a look at it.

Again, thank you for your help though!
Michelle