Vlookup/hlookup

[Ntema]

Hi,


I have been using excel help function but not getting my intended results; I always receive data in EXCEL as follows:
· Column A = RL (145
· Column B = ROCKGROUP (GKSAP)
· Column C = GRADEGROUP (WASTE)
· Column D = Volume (1582.236)

· Column A = RL (145
· Column B = ROCKGROUP (GKSAP)
· Column C = GRADEGROUP (MO)
· Column D = Volume (81582.236)
This data/table continues for all the data I need to analyze. Data in this formation takes much of my time to analyze it and not presentable. I have 12 Rock Groups (GKSAP; GKTR; GKFR; FWSAP; FWTR; FWFR; HWSAP; HWTR; HWFR; SOFTWAST; TRNSWAST; HARDWAST); 5 grade groups (WASTE; MO; LG; MG; HG) and 70 Levels (145.0 to 0.0) to analyze within 24hours and present.
I am much familiar with VLOOKUP/HLOOKUP. I am unable or don’t know how to use these functions with such an exercise. I am getting a 0 result or #N/A. my formula is as follows:
=VLOOKUP(A13;bench!$C$6:$F$1706;IF($C$1="GKSAP";2; IF($C$1="GKTR";2;IF($C$1="GKFR";2;IF($C$1="FWSAP"; 2;IF($C$1="FWTR";2;IF($C$1="FWFR";2;IF($C$1="HWSAP ";2;IF($C$1="HWTR";2;IF($C$1="HWFR";2;IF($C$1="SOF TWAST";2;IF($C$1="TRNSWAST";2;IF($C$1="HARDWAST";2 ;IF($C$2="WASTE";3;IF($C$2="mo";3;IF($C$2="mo";3;I F($C$2="lg";3;IF($C$2="mg";3;IF($C$2="hg";3;TRUE)) )))))))))))))))))
So please I need your help if there are any functions or is my formula not correct. I do arrange it in this formation (Table below) for better analysis and presentation. I want to arrange my table in this formation:
· Column A = RL (Cell A3 being my RL value)
· Column B = RL (Cell B1 being my ROCKGROUP; Cell B2 being my GRADEGROUP)
· Column C = RL (Cell C1 being my ROCKGROUP; Cell C2 being my GRADEGROUP)
· From Row 3 (B3) in reference to the RL the volumes should