close
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 amp; I
Help
--
Thanx n rgds
joe
全站熱搜