Thread: Vlookup to the left?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mac[_3_] Mac[_3_] is offline
external usenet poster
  
Posts: 9
Default Vlookup to the left?
=Vlookup(a1,Range,6,FALSE)

Vlookup will count 6 column to the right and grab the value. Can I use
Vlookup to count to the left something like -6?

Thanks,
mac

Reply With QuoteReply With Quote