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
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 23, 2012 at 11:35 PM
Related:
- Problem in Vlookup
- If iserror vlookup - Guide
- Transfer data from one excel worksheet to another automatically vlookup - Guide
- Concanating text using vlookup forumula - Excel Forum
- Using Vlookup to return insted of 00/01/1900 ✓ - Excel Forum
- Removing "FALSE" from an IF statement with a VLOOKUP ✓ - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 23, 2012 at 11:35 PM
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"
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"
