Tagged Questions

0
votes
2answers
292 views

Excel Lookup/Match exact match only

I am a bit confused with lookup/match and the lookup wizard in excel 07 does not seem to allow multiple sheets properly. What I need is for cell B2:BXXXX on Sheet 2 to run the following and display ...
0
votes
1answer
878 views

MS Excel 2010: VLOOKUP not working right?

Here's the data that I have on the "Components" sheet (B4:E13): Component 1 a Form Low Component 2 a Form Low Component 3 a Form Medium Component 4 a ...