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
- Number to words in excel - Guide
- Marksheet in excel - Guide
- How to take screenshot in excel - Guide
- Gif in excel - Guide
- Excel free download - Download - Spreadsheets
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
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.