Values Lookup in excel
Solved/Closed
seekermay
seekermay
- Posts
- 28
- Registration date
- Wednesday January 27, 2010
- Status
- Member
- Last seen
- May 27, 2013
seekermay
- Posts
- 28
- Registration date
- Wednesday January 27, 2010
- Status
- Member
- Last seen
- May 27, 2013
Related:
- Values Lookup in excel
- Complicated Lookup in Excel - How-To - Excel
- Complicated Lookup in Excel ✓ - Forum - Excel
- Comparing values of two Excel sheets ✓ - Forum - Excel
- To highlight a cell with duplicate values in an excel, what conditions can be used ✓ - Forum - Excel
- Image lookup in excel from folder - Forum - Excel
2 replies
rizvisa1
Feb 2, 2010 at 12:02 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Feb 2, 2010 at 12:02 PM
Most easy route would be if you can add one column on Master sheet
If you can insert a new column at C and put the formula at C1 as =A1 & "|" & B1
drag this formula all the way down
Then in the sheet two you can use vlookup as
for your C2 column the formula would be
=VLOOKUP($A2 & "|" & $B2, Master!$C$1:$H$8, 2, FALSE)
The number "2" before "false" refers to relative position from the newly inserted column to your column titled "value1"
If you can insert a new column at C and put the formula at C1 as =A1 & "|" & B1
drag this formula all the way down
Then in the sheet two you can use vlookup as
for your C2 column the formula would be
=VLOOKUP($A2 & "|" & $B2, Master!$C$1:$H$8, 2, FALSE)
The number "2" before "false" refers to relative position from the newly inserted column to your column titled "value1"
seekermay
Feb 2, 2010 at 12:19 PM
- Posts
- 28
- Registration date
- Wednesday January 27, 2010
- Status
- Member
- Last seen
- May 27, 2013
Feb 2, 2010 at 12:19 PM
Thanks!!!! Its simple and worked perfect.
Thanks again.
Thanks again.