Thread: Vlookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe
 
Posts: n/a
Default Vlookup

I 've a doubt in using Vlookup formula
Here in tis formula:: VLOOKUP(A4:A7,'Q6'!G3:I8,3,0), d axn tkng place is, xl
chks for range A4:A7 and see whtr thr is match for any items in 'Q6'!G3:I8
and prints the value of col 3(ie., Col I). Wot i want is to print both items
of col H & I
Help
--
Thanx n rgds
joe