LinkBack URL
About LinkBacks
Dear All
I have some question at my attached file
Can i use vlookup or seach function to find the result ?
Or have any formula to found ?
Thanks
How to use some formulas to search result ?
Dear All
I have some question at my attached file
Can i use vlookup or seach function to find the result ?
Or have any formula to found ?
Thanks
Hi,
I have seen your workbook.....it is not clear
I can not find AA2 and E3 text and what is your result E12 is range or text and what is ( 8x8 cm )
Search this word Result
AA2/E3 =E12 ( 8x8 cm )
Lokesh Kumar
Stay Hungry.. Stay Foolish..
_________________________________________________________
Please Click STAR to Add Reputation if my/someone's answer helped!
i have updated the file again , this that clear ?
search question1.xlsx
Why AA2/E3 is US$12 ( 8x8 cm )
will you explain the logic
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Sorry but I really do not understand the logic what to search and where you found that one and what is your result.......Please explain the logic......Originally Posted by jayshing
Sorry
Thanks all
Maybe like this?
Yes, Thanks you
=IFERROR(INDEX($E$2:$E$9,MATCH(SUBSTITUTE(MID($G8,FIND("/",$G8)+1,256),LOOKUP(9^9,MID(MID($G8,FIND("/",$G8)+1,256),ROW($1:$7),7)+0),""),$D$2:$D$9,0))&SUBSTITUTE(INDEX($B$2:$B$7,MATCH(LOOKUP(9^9,MID(MID($G8,FIND("/",$G8)+1,256),ROW($1:$7),7)+0),$A$2:$A$7,0)),"Size :"," (")&" )","")
dear azumi
if my keyword AA/E2 change to more words ( AA/E2 pack of sugar ) , how did set the formula ?
Try this
Please Login or Register to view this content.
see the attached file
Thanks ^^Try thisPlease Login or Register to view this content.
see the attached file
Bingo ~~~ >3<
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks