Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |