rawah alsandi R4 - AutoSave C 2 _ LOOKUPfunction - saved O Search File Home Insert Draw Page Layout Formulas Data Review View Help Power Pivot AUTOSAVE TURNED OFF This workbook contains features that prevent it from using AutoSave. Please save your workbook manually. 0 x Comments Share F51 .1 X J REQUIRED TO USE VLOOKUP OR HLOOKUP FOR THIS THREE QUIESTIONS G H I J K L M N O P Q R S T U V W X Y / Gross Pay Income Tax 3.000 40 Employee ID Dept 41 92-5001 HR 42 77-3407 IT 43 68-1000 ACCTG 44 77-3410 F INANCE 45 05 ecco IT 46 99-5989 HR 47 TOTAL 5 CRNI 15.000 14.000 7.000 3. Create a Inok-up table bainw Tax Rate look up Table as Uw in row 50 Wilo u formula inslui vull D41 with proper functions) o corpule the Income Tax based upon the following schedule If gross pay $6.000. the tax rate is 10%. It mss p