Excel 2007 : Extracting data from two columns and only using info from one.

[hilltopper]

I have four columns all text.
Column 1 has data that is random and the row it's in changes daily.
Column 3 has the same data as column 1 but in a static order.
Column 4 has static data that says the data in each row in column 3 is either Labor or Nonlabor.

I would like to be able to write a formula in Column 2 Row 1 that would match up the data in Column 1 Row 1 with the same data in Column 3 Row ?? but only return the value in column 4 (either Labor or Nonlabor) of that match.

I will then just fill down for each row with the formula.

Thanks for any help.

[Andrew-R]

You need an index and match (and, incidentally, a more descriptive title for this thread ... read the forum rules)

=INDEX(D:D,MATCH(A1,C:C,0),1)

[hilltopper]

Wow, what a rapid response. Thank you so much I will give it a try. As for the post title, I've changed it already. Not thinking, Sorry about that.

[hilltopper]

I have changed the Title. Won't happen again.

[hilltopper]

I used the formula given. However, I receive a value in column 2 of #N/A. The particular value in column 1 row 1 is 18T. In columns 3 and 4 the value of 18T and Nonlabor are on row 2. I need the value on row 2 column 4 as a result. Thanks.

[Andrew-R]

Could you post an example worksheet?

[hilltopper]

Attached is the worksheet I'm using.

[Nikeyg]

Doesn't help that the data in Column 3 has erroneous spaces in it.
Do a Ctrl+H, and replace the spaces with nothing then do a regular Vlookup against it and you'll have your result.

[Andrew-R]

The issue is that the data in column C has been centred by putting leading spaces in front of it(!).

If you change my formula to =INDEX(D:D,MATCH("*" & A1,C:C,0),1) it will work fine.

[hilltopper]

Thanks to Nikeyg and Andrew.R for the excellent help. That solved the problem and I'll mark it as such. Excellent help. Hopefully I'll become better at this in time.