ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Vlookup (https://www.excelbanter.com/excel-discussion-misc-queries/69972-vlookup.html)

Joe

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