Values Lookup in excel
Solved/Closed
seekermay
Posts
28
Registration date
Wednesday 27 January 2010
Status
Member
Last seen
27 May 2013
-
2 Feb 2010 à 11:28
seekermay Posts 28 Registration date Wednesday 27 January 2010 Status Member Last seen 27 May 2013 - 2 Feb 2010 à 12:19
seekermay Posts 28 Registration date Wednesday 27 January 2010 Status Member Last seen 27 May 2013 - 2 Feb 2010 à 12:19
Related:
- Lkkljk
- Excel mod apk for pc - Download - Spreadsheets
- Arrow keys not working in excel - Guide
- Vat calculation excel - Guide
- Kernel for excel repair - Download - Backup and recovery
- Number to words in excel - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
2 Feb 2010 à 12:02
2 Feb 2010 à 12:02
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 27 January 2010
Status
Member
Last seen
27 May 2013
5
2 Feb 2010 à 12:19
2 Feb 2010 à 12:19
Thanks!!!! Its simple and worked perfect.
Thanks again.
Thanks again.