Good Morning all,
I have a workbook where I need to use a Vlookup to get pricing by work location and EE Name. Basically, I'm trying to use a vlookup to lookup the named range (Ranges tab, rows 1-3) and then use that named range in another vlookup to get the pricing for that work location. I need the results to show up on the Data tab in column G. I tried the following to no avail:
=VLOOKUP(F2,"Ranges!" & VLOOKUP(Ranges!A1:B3,2,FALSE),2,FALSE)
The data is extracted from an access database and I need to format for billing statements to different EE's with different work locations.
For row 2 on the data tab, i would need it to return 20 (AB&C Co / Urban location)
For row 3 on the data tab, I would need it to return 15.
Any help would be appreciated.