Problem in Vlookup

Closed

Raam - Jul 21, 2012 at 06:51 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 23, 2012 at 11:35 PM

Hello,
I have one column (Item) 200 records in one excel and the same column(Item) 350 records and one more column(Price) in second excel sheet. now i want value from second excel to first excel sheet for price column compare with item by using Vlookup. Pls help me if anybody know..

Problem in Vlookup
Transfer data from one excel worksheet to another automatically vlookup - Guide
Vlookup date 1/0/1900 ✓ - Excel Forum
Automatically transfer data from one sheet to another ✓ - Excel Forum
Removing "FALSE" from an IF statement with a VLOOKUP ✓ - Excel Forum

1 response

Answer 1 / 1

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jul 23, 2012 at 11:35 PM

would have been helpful if you had given a very small extract of both sheet

suppose your sheet 1 is like this

hdng1
a
s
d
f

secnd sheet is

hdng1 price
a 1
d 2
g 3

in the first ssheet in B2 type this formula

=VLOOKUP(A2,Sheet2!$A$2:$B$100,2,0)

it would be helpful to you if you study the help under "vlookup"

Similar discussions

Match partial text string in one sheet to another text string in another sheet

Compare values in two columns and return the value from third

Conditional Formatting in a vlookup

Find missing data in 2 columns (Excel)

Concanating text using vlookup forumula

Similar discussions

Subscribe To Our Newsletter!