How to fetch mulitple rows and columns by giving single VLOOKUP() function...?

H

Hitesh

Joined
Apr 25, 2006
Messages
1
Reaction score
0
Hi,

I have 2 sheets. In 'Sheet5' I have all the source data and in 'Sheet1' I want the result by typing a Customer Code in column C7, it will match the customer code in Sheet5 and fetch the only 1 record. I have tried with Vlookup() function but it gives me only 1 record. Can anybody help me to fetch the multiple rows and columns by giving single command (i.e. Column D, E and G from Sheet5) it will display result in Sheet1 in column B to D..............Please help..............

Hitesh.......Its very urgent..........Can somebody help me................
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup function 1
Help Required 3
Large & Vlookup functions 2
Vlookup Help :) 3
VBA to automatically cut, paste entire row based on date input and delete row 0
For Each Cell in Sheet1 Range, do some Vlookup calc. from Sheet3 5
Vlookup 6
Search the column and return a cell value 15

Top