View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gcw gcw is offline
external usenet poster
 
Posts: 9
Default Lookup formula for both row and column

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)