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 |
All times are GMT +1. The time now is 08:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com