Search for text and return values

[Ninja2k]

I have two sheets in my workbook, Main Specs is where I have a list of specifications, I need to tidy them into my sheet named specs.

I need a formula to do something like this:

Using the Text in G4 to V4, I want to search main specs for that text and return the value from column B

I want to put the values into g6, H6 etc

I need the the first set of values to go on row 6 the second on row 7 etc


E.g.

Search for Product Description in the sheet Main Specs
Finds Product Description at 'Main Specs'!A2
Return Value Toshiba Satellite Pro L830-17T - 13.3" - Core i3 3227U - Windows 8 64-bit - 2 GB RAM - 500 GB HDD
Put value at G6


Can this be done wit ha formula?

[L-Drr]

Put this in Specs!G6 and drag to the right

=VLOOKUP(G4;'Main Specs'!$A:$B;2;FALSE)

Maybe my semicolons should be commas for you


Edit: just saw that there are several products in the main specs sheet; the formula above only works for the first product

[Ninja2k]

So far so good, is there anyway to get this working for the other products?

[hemesh]

Hello, Are you looking for this !!



If answer helps you, click " * " add rep icon in the bottom left post of my corner and mark thread as solved.

Just drag the formula down and left to right.

Regards

[Ninja2k]

Hello, Are you looking for this !!

If answer helps you, click " * " add rep icon in the bottom left post of my corner and mark thread as solved.

Just drag the formula down and left to right.

Regards

That is one complicated formula, you have done this before :D thanks for that! Much appreciated.

[hemesh]

you just need to change the references for your formula and thats all! then Drag the formula top to bottom and left to right!! If you have any problem you can always be in touch