Values Lookup in excel
Solved/Closed
seekermay
Posts
28
Registration date
Wednesday January 27, 2010
Status
Member
Last seen
May 27, 2013
-
Feb 2, 2010 at 11:28 AM
seekermay Posts 28 Registration date Wednesday January 27, 2010 Status Member Last seen May 27, 2013 - Feb 2, 2010 at 12:19 PM
seekermay Posts 28 Registration date Wednesday January 27, 2010 Status Member Last seen May 27, 2013 - Feb 2, 2010 at 12:19 PM
Related:
- Values Lookup in excel
- Excel date format dd.mm.yyyy - Guide
- Https //accounts.google.com/sign in/v1/lookup - Gmail Forum
- Number to words in excel - Guide
- Based on the values in cells b77 b81 ✓ - Excel Forum
- Screenshot in excel - Guide
2 replies
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Feb 2, 2010 at 12:02 PM
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
Posts
28
Registration date
Wednesday January 27, 2010
Status
Member
Last seen
May 27, 2013
5
Feb 2, 2010 at 12:19 PM
Feb 2, 2010 at 12:19 PM
Thanks!!!! Its simple and worked perfect.
Thanks again.
Thanks again.