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
Hi, and welcome to the forum.
In B1 and copied down
RgdsCode:=IF(AND(A1>=1,A1<=42),A1,"")
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star iconat the bottom left of my post.
hi, wow, that was really fasthowever 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
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
If this was useful then please rate it appropriately.
Click the small star icon
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
RgdsCode:=IF(AND(1*MID(A2,MATCH(TRUE,ISNUMBER(1*MID(A2,ROW($1:$9),1)),0),COUNT(1*MID(A2,ROW($1:$9),1)))>=1,1*MID(A2,MATCH(TRUE,ISNUMBER(1*MID(A2,ROW($1:$9),1)),0),COUNT(1*MID(A2,ROW($1:$9),1)))<42),1*MID(A2,MATCH(TRUE,ISNUMBER(1*MID(A2,ROW($1:$9),1)),0),COUNT(1*MID(A2,ROW($1:$9),1))),"")
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star icon
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.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
It depends what the value is you want to match I think
For a set value enter into B1
and fill down.Code:=IF(A1="Value",A1,"")
To return matches between columns A and B, in the relevant cell in column C, enter this into A1 and fill down
Code:=IF(A1=B1,A1,"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks