0
votes
2answers
31 views

MS Excel using multidimensional lookup

Hi am trying to assign a value given that if I have a some value that matches column 1, it will search try to check if for that specific row my my product variable is lesser than specified. So let's ...
0
votes
3answers
99 views

Lookup range of words in range of sentences

Based on the following example: I want to look up for words from the $D$2:$D$6 range in sentences from the $A$2:$A$8 range and use the value from the side column (here Tag). So far I'm doing this: ...
0
votes
2answers
556 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 ...
1
vote
1answer
928 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 ...