Looking for formula.
Closed
ahamaz
Zohaib R
- Posts
- 4
- Registration date
- Tuesday April 23, 2013
- Status
- Member
- Last seen
- October 31, 2013
Zohaib R
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Related:
- Looking for formula.
- Spreadsheet formula - Articles
- Excel @ in formula ✓ - Forum - Excel
- Little alchemy formulas - Guide
- 1st, 2nd, 3rd position formula in excel ✓ - Forum - Office Software
- Logitech formula vibration feedback wheel driver windows 10 - Download
1 reply
Zohaib R
Apr 23, 2013 at 11:32 PM
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Apr 23, 2013 at 11:32 PM
Hi ahamaz,
You can find the matching values from the other table/worksheet using Microsoft Excel's VLOOKUP() Worksheet Function. For example to find the matching value for "ireland" and put it in the D1 use the below mentioned formula in D1:
=VLOOKUP(A1,$E$1:$G$5,3,0)
To delete a value you might need to use a Macro.
Please reply if you need any further clarification.
You can find the matching values from the other table/worksheet using Microsoft Excel's VLOOKUP() Worksheet Function. For example to find the matching value for "ireland" and put it in the D1 use the below mentioned formula in D1:
=VLOOKUP(A1,$E$1:$G$5,3,0)
To delete a value you might need to use a Macro.
Please reply if you need any further clarification.