i have a table with numbers in Excel like this :
A B
string1 14521
string2 121
stringN 255
i have another table with the same strings where i need to insert the corresponding number (e.g. 121 for string2):
A B C
blabla string1 <i need to place here the contents of row B in table above >
blabla string2 <i need to place here the contents of row B in table above >
blabla stringn <i need to place here the contents of row B in table above >
which formula should i use in cells C to do that please ? i tried a bunch of things with combinations of IF/VLOOKUP/MATCH but didn't manage to do it :( (showing the contents of cell B in table 1 for each matching string of column B)
thanks !