If then on Excel for Mac

[tpedry1]

I have posted a short video below to explain what I am needing to do. Thank you for anyone's help with this (more than likely) simple formula! I am a novice so please be gentle!

Dropdown_List_Data - jattalla's library

Thank you,

Tim

 

[bschwartz]

Try this formula in cell AF2 on worksheet Blue Mantle Copy. Copy across to cell AG2, and down as needed.

=VLOOKUP(AE2,'Labor Codes'!$A$1:$C$30,COLUMN('Labor Codes'!B$1),0)

 

[bschwartz]

Correction:

=VLOOKUP($AE2,'Labor Codes'!$A$1:$C$30,COLUMN('Labor Codes'!B$1),0)

 

[tpedry1]

Correction:

=VLOOKUP($AE2,'Labor Codes'!$A$1:$C$30,COLUMN('Labor Codes'!B$1),0)

Thank you Ben

What is the quick little adjustment that I need to add to the formula to get rid of the N/A?


-- removed inline image ---

 

[bschwartz]

I can't see the picture you posted. Are you getting an N/A error in cell AF2?

 

[tpedry1]

 

[tpedry1]

Thanks a ton Ben! I added the iferror(if(Sum(...,""),"") in there and it took care of my issues!

thanks

 

[bschwartz]

You're very welcome.