View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lindsayhyle lindsayhyle is offline
external usenet poster
 
Posts: 17
Default vlookup and hlookup in the same formula

Hi,
I have a spreadsheet that I would like to pull data from a pivot table on a
different sheet. The data I have would need to pull from both the rows and
the columns. It would look like this:
Labor Code x Labor Code y Labor Code z
Name
Name
Name
Name

I would like the lookup to reference the name and the labor code from the
pivot table. Is there a way to combine a Vlookup with an Hlookup? Thanks.