Not your question?
Ask your question
View similar questions
Add your answer here.Check out some similar questions!
Vlookup formula
[ 2 Answers ]
I am currently using MS-Excel 2003. Having a terrible time with Vlookup. The concept seems easy enough – but I can’t get it to work with just 2 spreadsheets – and pulling only 1 column from the other spreadsheet. I have these fields on one spreadsheet. Worksheet Tab 1 Worksheet Tab 2...
Sum multiple Vlookup results
[ 2 Answers ]
Hello, Is there a function that can sum multiple Vlookup results? I hate doing this to sum 3 Vlooukup results: =VLOOKUP($I3,AFFINITY,7,FALSE)+VLOOKUP($I3,AFFINITY,8,FALSE)+VLOOKUP($I3,AFFINITY,9,FALSE) Thanks, Gen
Limitations of VLOOKUP
[ 3 Answers ]
I have a column of values that can't be put in ascending order. 20 55 3 61 2 etc. I want to lookup another value that corresponds to each of these numbers. View more questions Search
|