I'm working on a spreadsheet to list work orders for customers needing PC and
laptop repair. Some of the jobs will be under warranty and others not. Can a
Vlookup be conditional like this. If the computer is under warranty then one
result is returned showing this. If it is not under warranty a differen
result is returned. Example, one column asks if the computer is under
warranty. If "Y" or "Yes" is in that column then the result would return
Total Cost for labor only. If there is an "N" or "No" then the result would
reflect Total Cost for labor and parts.