There is 2sheets of excel, in sheet1 it has borrower id and product type column, here I want to compare product type with borrower id (unique)and change product type as per sheet1
There is 2sheets of excel, in sheet1 it has borrower id and product type column, here I want to compare product type with borrower id (unique)and change product type as per sheet1
What is the expected answer for 908010915??
If it is a blank (908010915 is not on sheet 1), then try:
=IFERROR(INDEX(Sheet1!O:O,MATCH(Sheet2!B2,Sheet1!B:B,0)),"")
in O2 of sheet 2.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
908010915
908011307
908013311
908013601 it want to remain the same whatever it exists already in sheet2 but it shows blank, pls do the change in formula and send again
my expected answer is, in sheet1 this id not available means then in sheet2 it want to remain the same like,
908010915 sanitation
908011307 water
908013311 Water Filter
908013601 sanitation
OK. You cannot get Excel to "remember" a value in that way. If the ID number is not present, it can ONLY return a blank. To do what you want, you will need VBA. Is that OK? I cannot help you (no good with VBA), but I can move it to the VBA sub-forum where someone else will help. Let me know...
no, i need in excel only
Then you cannot do it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks