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.

=IF(A1="Y",formula to get labor cost only,formula to get cost for for labor
and parts)

assuming Col A has Y/N...

example
=IF(A1="Y",100,150)

You can replace 100 and 150 with cell references or calculations
=IF(A1="Y",B1,C1) if B1 has labor cost only and C1 has labor+parts...

Hope you get the idea. Instead of B1 and C1 you can have VLOOKUPs...

Copy the formula down to other cells... as required.


"dvonj" wrote:

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.

I think I get it. So if A1=Y use vlookup1 and if A1=N use vlookup2? I might
add that the results retunred would correspond to the type of job being done
as well as if the unit is under warranty or not.

"Sheeloo" wrote:

=IF(A1="Y",formula to get labor cost only,formula to get cost for for labor
and parts)

assuming Col A has Y/N...

example
=IF(A1="Y",100,150)

You can replace 100 and 150 with cell references or calculations
=IF(A1="Y",B1,C1) if B1 has labor cost only and C1 has labor+parts...

Hope you get the idea. Instead of B1 and C1 you can have VLOOKUPs...

Copy the formula down to other cells... as required.


"dvonj" wrote:

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.

Yes, you got it right...

Pl. click 'Yes' if this was helpful...

"dvonj" wrote:

I think I get it. So if A1=Y use vlookup1 and if A1=N use vlookup2? I might
add that the results retunred would correspond to the type of job being done
as well as if the unit is under warranty or not.

"Sheeloo" wrote:

=IF(A1="Y",formula to get labor cost only,formula to get cost for for labor
and parts)

assuming Col A has Y/N...

example
=IF(A1="Y",100,150)

You can replace 100 and 150 with cell references or calculations
=IF(A1="Y",B1,C1) if B1 has labor cost only and C1 has labor+parts...

Hope you get the idea. Instead of B1 and C1 you can have VLOOKUPs...

Copy the formula down to other cells... as required.


"dvonj" wrote:

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.