Dear Experts,
I am trying to vlookup value from sheet2 to sheet3 but the formula did not work. Please see the attachment file.
Thank you in advance
Dear Experts,
I am trying to vlookup value from sheet2 to sheet3 but the formula did not work. Please see the attachment file.
Thank you in advance
Probably a rounding error. Try this:
=INDEX(Sheet2!B$3:B$65010,MATCH(ROUND($B3,2),Sheet2!C$3:C$65010,0))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
The numbers in sheet 3 column B are not being properly seen as numbers.
In column C of sheet 3 enter a formula and copy it down all your rows - start in cell C2
Copy down all rows,Please Login or Register to view this content.
Then copy all those cells and then click on Cell B2 in sheet 3 and use a paste special / paste values to insert the numbers correctly.
Tidy up column C by deleting the formulae
Try this:
Highlight B3:B177 > Data > Text to Columns > Finish
AliGW, Thank you so much.
Is it possible to give directly results in column A? example avoiding the column D and directly reach the result.
Yes, but I am not sure what you want there. Maybe this?
="GAIL-MSA-XYZ-CS-" &INDEX(Sheet2!B$3:B$65010,MATCH(ROUND($B3,2),Sheet2!C$3:C$65010,0))&"-"&TEXT(COUNTIF($E$3:E3,E3),"000")
Just like the formula shown below, but without reference column "e"
="GAIL-MSA-XYZ-CS-" &IF(ISERROR(VLOOKUP(INDEX(Sheet2!B$3:B$65010,MATCH(ROUND($B3,2),Sheet2!C$3:C$65010,0)),Sheet1!$A$2:$C$300,2,FALSE)),INDEX(Sheet2!B$3:B$65010,MATCH(ROUND($B3,2),Sheet2!C$3:C$65010,0)),VLOOKUP(INDEX(Sheet2!B$3:B$65010,MATCH(ROUND($B3,2),Sheet2!C$3:C$65010,0)),Sheet1!$A$2:$C$300,2,FALSE))&"-"&TEXT(COUNTIF($E$3:E3,E3),"000")
Last edited by sanju2323; 08-29-2018 at 08:32 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks