Retrieving Data from Sheet1 into Sheet2

[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

 

[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