Retrieving Data from Sheet1 into Sheet2

A

Akash

Hi,

This is regarding few information that i required to retrieve data

I have two sheets

in Sheet 1 i have two Columns with the entire data

Item Name
Rates
Qty

in sheet2 i have again two columns but with no data


Items Name
Rates

Now i want some thing which can help me to get the desired output:

if it matches the item Name of Sheet1 & Sheet2 then it should retrieve
Rates in Sheet 2 Column.

What should i do in this regards

Akash
 
G

geniusideas

Hi,

This is regarding few information that i required to retrieve data

I have two sheets

in Sheet 1 i have two Columns with the entire data

Item Name
Rates
Qty

in sheet2 i have again two columns but with no data

Items Name
Rates

Now i want some thing which can help me to get the desired output:

if it matches the item Name of Sheet1 & Sheet2 then it should retrieve
Rates in Sheet 2 Column.

What should i do in this regards

Akash


Dear Akash,

I think you should use vlookup() function, go to help search for
vlookup function.
and don't forget to use $ sign in order to fix your table array when
you drag down the formula.
Example $A1:$B5
http://microsoft-excel-macro.blogspot.com
 

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

Top