Calculating Date Based on Priority

Are you allowed to put that table somewhere in the spreadsheet to use as a lookup table? I would simply put that table into the sheet, then use one of Excel's lookup functions https://support.office.com/en-us/art...8-93a18ad188a1

C1=B1+VLOOKUP(A1,absolute_reference_to_lookup_table,2,FALSE)

References to other sheets in the same workbook simply need the sheet name +! added to the reference
'sheet1'!$A1:$C5 would refer to A1:C5 on sheet1. The single quotes are only needed when the sheet name contains certain characters, so this reference technically does not need the single quotes around the sheet name. I find that the easiest way to make certain the syntax is correct is to "point and click" on the range (while entering the formula, use the mouse or arrow keys to select the desired range on the desired tab). Excel will enter the reference with the correct syntax.

Works Perfect! Thank you for your assistance and time MrShorty! Below is the breakdown for my situation as an example.


=B2+VLOOKUP(A2,Sheet2!A2:B5,2,FALSE)


1.
B2=Available Date

2.
VLOOKUP=Command to perform action

3.
A2=Priority Category (Low, Medium, High, Critical)

4.
Sheet2!=Sheet with the Table Data (only necessary if you place table data on another sheet)

5.
A2:B5=Table Data Range
(Sheet2!A2=Low
Sheet2!A3=Medium
Sheet2!A4=High
Sheet2!A5=Critical
Sheet2!B2=75
Sheet2!B3=52
Sheet2!B4=25
Sheet2!B5=15)

6.
2= Which column of table data to display. In my case I want the number of days, column 2, to add to the date available in B2.

7.
False=Give exact match for data in table