Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel 2000 Question 1
- Thread starter pappion
- Start date
SkipVought
Programmer
Hi,
Where is your lookup table?
Generally, here's the approch..
in A2
in A3
Hope this helps 
Skip,
Skip@TheOfficeExperts.com
Where is your lookup table?
Generally, here's the approch..
in A2
Code:
=Index(YourDescriptionRange,Match(A1,YourItemNumberRange,0),1)
Code:
=Index(YourAmountRange,Match(A1,YourItemNumberRange,0),1)Skip,
Skip@TheOfficeExperts.com
-
1
- #3
Hello,
This can be solved easily with the Vlookup function, but as Skip mentioned you need a reference table with the values and the descriptions.
Supposing range E1 to F10 contains the values to lookup (column e) and the descriptions (column f), the formula in A2 should look like this:
The if function is only added to avoid errors if A1 is empty or not matching with an item from the reference table.
Regards,
Bit
This can be solved easily with the Vlookup function, but as Skip mentioned you need a reference table with the values and the descriptions.
Supposing range E1 to F10 contains the values to lookup (column e) and the descriptions (column f), the formula in A2 should look like this:
Code:
=if(isna(vlookup(A1;E1:F10;2;0);" ";vlookup(A1;E1:F10;2;0))Regards,
Bit
- Status