LOOKUP formula

[jmonteiro]

hi, this is my first post so im sorry if its not done in the right place or maner, my problem is i need to get a lookup formula to look into a colum for a value and if that value is found to copy it to the same raw but in another colum:

look in Colum A for value 1:42 if that value is found in A3, A15, A45 then copy that value to B3, B15, B45. i hope im making myself understand and some good soul can help me out.

many thanks in advance.

Jorge

[Richard Buttrey]

Hi, and welcome to the forum.

In B1 and copied down

Please Login or Register  to view this content.

Rgds

[jmonteiro]

hi, wow, that was really fast however its not working for me, maybe i didnt explain very well what i wanted, in my sheet in colum A i have 1300 raws with a product description and in that product description i have the product code in the midle of the description, i need to creat a new colum B just with that product code and it needs to be on the same raw, there are 23 diferent codes in those 1300 cells so i just need to look for those codes and copy them to a new colum. i hope this explains a bit better, im so sorry if it doesnt. thanks in advance

jorge

[Richard Buttrey]

Hi,

It will be easier to help if you can upload a sample of your data which contains all possible permutations of your data.

Regards

[Richard Buttrey]

Hi,

...and perhaps if I understand the requirement correctly, as an array formula in B1, i.e. enter this with Ctrl Shift Enter and then copy down to rows 2:nn

Please Login or Register  to view this content.

Rgds

[DonkeyOte]

jmonteiro, welcome to the Board

Going forward please try to post in most appropriate forum - I appreciate this is not as straightforward as it should be given the layout.

This thread has been moved to Worksheet Functions from Tips & Tutorials - the latter being a non-Question orientated forum.

[brzpptp2]

It depends what the value is you want to match I think

For a set value enter into B1

Please Login or Register  to view this content.

and fill down.

To return matches between columns A and B, in the relevant cell in column C, enter this into A1 and fill down

Please Login or Register  to view this content.