Need help with INDIRECT and VLOOKUP

djl0525

Well-known Member
Workload Detail!E11 contains "Sub Total 01:"
column E contains Sub Total 01:, Sub Total 02:, Sub Total 03:, etc.

Workload by AH!A7 contains "01" (the sub total number)
Workload by AHG5 contains "B Fund"

In Workload by AH!G7 (the intersection of A7 and G5) I need a formula that will lookup the Sub Total 01 for B Fund on the Workload Detail! sheet. Right now the answer is in Workload Detail!G11 (the intersection of E11 and G5), but as I refresh the data over time it won't always be in that cell.

I think my formula needs to use the INDIRECT and the VLOOKUP functions, but I can't figure it out. I hope this makes sense. Any help will be appreciated.

DJ

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Andrew Poulsom

MrExcel MVP
Try something like:

which can be copied down and across.

You may want to expand the ranges E5:I13,E5:E13 and E5:I5.

HTH

Replies
0
Views
1K
Replies
2
Views
296
Replies
0
Views
233
Replies
0
Views
183
Replies
10
Views
437

1,195,748
Messages
6,011,429
Members
441,614
Latest member
TiaGtz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back