View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric D Eric D is offline
external usenet poster
 
Posts: 50
Default Vlookup and Hlookup

Is it possible to have a formula use both vlookup and hlookup together?

for example if i have a columns and rows that could change, but i have
labels in those that remain constant. Can i do a hlookup to find correct
column and then a vlookup to go to the right row to retrieve one value?



--
Eric