G
gcw
I am trying to do a lookup on both row and column. My spreadsheet has
targets per cost center (Rows) by Months (Columns) starting in Column D. The
"Row" lookup is working but how do I add the second portion. See ???? below
This is the formula I have so far:
=VLOOKUP($A3,TLTargets!$A$46:$Q$86,????,FALSE)
targets per cost center (Rows) by Months (Columns) starting in Column D. The
"Row" lookup is working but how do I add the second portion. See ???? below
This is the formula I have so far:
=VLOOKUP($A3,TLTargets!$A$46:$Q$86,????,FALSE)