If, V-lookup combination

[gambils]

Trying to have this formula look for numbers starting with 404 to find a "cost center description" on another tab of my worksheet. If the number does not start with 404, I want the if formula to return a result of "N/A".

But the following formula is getting an error message- what is wrong with it?

=if(C4=404*,=vlookup('404 Descriptions'!A:B,2,false),"N/A")

Thanks!

 

[cb12]

Try:

=IF(LEFT(C4,3)=404,VLOOKUP('404 Descriptions'!A:B,2,FALSE),"N/A")

 

[VoG]

Try

=if(C4="404*",vlookup('404 Descriptions'!A:B,2,false),"N/A")

 

[cb12]

Correction to my formula:

=IF(LEFT(C4,3)="404",VLOOKUP('404 Descriptions'!A:B,2,FALSE),"N/A")

Looking at your formula again it also seems you have forgotten to give a value to search for in the vlookup

 

[gambils]

Good catch on not putting in a search value. I've gotten it work using the "Left" formula. Will continue to play with the other.

Thanks!